Filtering data

[dealwi8me]

Hello all,

I have a table of data in Excel and i want to do a filtrering of this form:

Starting table:
Id | Val
=========
50050 2,7
50055 15,5
50055 3,7
50058 2,8
50058 9
50058 7
50088 5,4
50091 3,5
60006 3,3
50037 1,4

Table after filtering:
Id | Val
===========
50050 2,7
50055 19,2
50058 18,8
50088 5,4
50091 3,5
60006 3,3
50037 1,4

What i want to do is to take the rows with the same ids do the SUM of Val and appear it on the sheet only one time with val=sum.

Is it possible to do this with excel?(Not manually because i might have 5000 rows...)

[AlfD]

Hi!

Yes.

Use Data > Subtotal with Col A: subtotal to appear in col B.
Then use the little number-boxes which appear at the left of the table to get a view with only the subtotals showing. (Button 2 should do it)

Now you need to copy the visible cells: highlight aCols A & B: hit F5: choose special and then the button for visible cells only.

Now paste this to another place - probably best another worksheet.

If you don't like the fact that it says Total of 50050 and so on, Find Total of and Replace with nothing will tidy it up.

Alf

[dealwi8me]

First of all thank you for your answer!

I have another question...If I have more than these 2 columns is it possible to get the data of the other columns (of the subtotal rows) as well(without changes)?

Because with subtotal i only get the 2 columns ...