close
I subtotaled (sum) on 3 columns based on changes in a 4th column. There is a
5th column (repeating text info in all cells in the subtotaled groups) that I
want to display in the subtotaled (level 2) row. How do I get it to show?
Hi
Go to Data/Subtotals again and select the subtotal requirement. Make sure
you uncheck 'Replace current subtotals' before you click OK.
Andy.
quot;grjkquot; gt; wrote in message
...
gt;I subtotaled (sum) on 3 columns based on changes in a 4th column. There is
gt;a
gt; 5th column (repeating text info in all cells in the subtotaled groups)
gt; that I
gt; want to display in the subtotaled (level 2) row. How do I get it to show?
全站熱搜