Thread: Transaction type/ Transaction amount in two separate columns
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Transaction type/ Transaction amount in two separate columns
In the menu select DataSubtotals


"Mike" wrote:

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.
Reply With QuoteReply With Quote