View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Transaction type/ Transaction amount in two separate columns

I have a couple thousand rows of data grouped into eight transaction types.
Column A is the type and Column B is the amount. I would like average the
amounts of each of the groups. Can you give me an idea how best to approach
this task? It is repetitive in that this report is prepared on a weekly basis.