Using the subtotal function in Excel is rather straightforward and easy. However, the default formatting after using the function isn’t what I want. For example, let’s say that column A contains a list of dates, companies and their income for that date - something like this: (The list has previously been sorted so that the companies are grouped together.)
Col A______Col B__________Col C
1/2/14___Company A______532.12
1/6/14___Company A______ 31.58
1/10/14__Company B______123.00
1/15/14__Company C______ 10.52
1/20/22__Company C______100.31
(Sorry for using underlines - couldn’t preserve the columnar formatting by just using spaces.)
Now if the Subtotal routine has been run, calculating the subtotals for each company, Excel will correctly calculate the total amount of income for each company and insert this into a line after each group of companies. For Company A this list will have the statement “Total Company A”, and then in column C, the total amount - in this case, 563.70. This will continue for the entire list, showing the total amount each company earned and inserting it after each group of the same company.
My problem with this is that, to me, having these subtotals placed in the same column as the individual incomes (C, in this case), results in a big list with all the numbers, both individual and subtotals, right under each other, and is somewhat confusing to read and/or review.
Like this:
Col A______Col B__________Col C
1/2/14___Company A______532.12
1/6/14___Company A______ 31.58
Total Company A____563.70
1/10/14__Company B 123.00
Total Company B____123.00
1/15/14__Company C 10.52
1/20/22__Company C______ 100.31
______Total Company C____110.83
As you can see, this format is not clear or easily read
What I want Excel to do is to not put the subtotals into column C, but instead leave the cell in column C blank, and place the subtotal instead into Column D. So the result would look like this:
Col A______Col B__________Col C______Col D
1/2/14___Company A______532.12
1/6/14___Company A______ 31.58
Total Company A______________563.70
1/10/14__Company B 123.00
Total Company B______________123.00
1/15/14__Company C 10.52
1/20/22__Company C______ 100.31
______Total Company C______________110.83
To me, this format is much clearer than the previous one.
So far, nothing I’ve tried (including reading the help files), will generate this formatting. If any Excel experts out there can help, I’d be most appreciative.
