Subtotals - show all columns?


B

Ben

Is there a way using the Data => Subtotal feature to show all columns instead
of just the total?

Ex.

Column A - Account
Column B - Name
Column C - Value
Column D - Funny Word

At each change in Column A, I want to sum Column C. However, I also want
Columns B & D to be shown on the same row instead of those related cells
being blank?

I suppose I could concatenate the columns, subtotal, copy/paste special the
values, and then use the text-to-column feature to split the concatenation,
but that seems to be the long way.

Thanks, Ben
 
Ad

Advertisements

S

Sheeloo

I am not sure it is the best way but try this...
After entering SUBTOTAL formula
Select whole range...
Press F5, click Special and choose blanks
On the first blank cell (assuming it is B10) type
=B9
and press CTRL-ENTER (type the address of the cell in the previous row and
same column as the first blank cell
 
Ad

Advertisements

B

Ben

I think it would work, but it errored out since the selection was so large.
I was able to use the concatenate / text-to-column procedure which worked.

Thanks for your suggestion, Sheeloo.

Ben
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top