Hi Jim,

1) first option is not good, I need to use autofilter afterwards, so the ID
needs to remain in its column.

2) what is a pivot table? Can you give more details, as I would like to try
your option at least.

Thanks.

"Jim Thomlinson" wrote:

2 other possibilities...

1 - Add a new column and create a concatenated field of both the ID and the
Name. Use this new field as the basis of the subtotal

2 - Use a pivot table. Add both the name and ID to the left ahnd column and
the amaounts to the data section (this would be my prefered method).
--
HTH...

Jim Thomlinson


"Timo" wrote:

Hi Pete,

thanks, nice one, even though it takes a few steps...no other possibility?

Cheers,

Timo

"Pete_UK" wrote:

Highlight the ID column and then press F5 (GoTo), click on Special,
then on Blanks. Then begin to enter a formula by typing =, then click
on the cell immediately above the first blank (it will be the last one
that has 1234 as an ID in your example), and then do CTRL-Enter. All
the blank cells will be filled with a formula which will copy the ID
from the line above.

Hope this helps.

Pete

On Aug 25, 2:30 pm, Timo wrote:
Dear all,

I want to use subtotals for Name, to sum the amounts. I would get a total
line for Name1 with value 300... However I would also like to see the ID in
the total line. How do I do that? Thanks in advance.

ID Name amount
1234 Name1 100
1234 Name1 200
2000 Name2 125
2000 Name2 200
[...]