Thread: filtering
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default filtering

Add headers to each column if you don't have them.

Then select columns A and B (and any other used column)
Data|Sort
(and sort by column A)

Then Data|Subtotal
Subtotal by each change in the description column



halb1961 wrote:

I have two colums. A description column and an amount column. How do I
subtotal the descriptions?


--

Dave Peterson