Subtotals - show all columns?
 

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

Subtotals - show all columns?
 

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

"Ben" wrote:

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

Subtotals - show all columns?
 

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

"Sheeloo" wrote:

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

"Ben" wrote:

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