Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to compare the lists in two columns & separate odd one ? | Excel Discussion (Misc queries) | |||
special type of rows to columns procedure | New Users to Excel | |||
Sum of columns until you a certain amount | Excel Discussion (Misc queries) | |||
split a single column into 2 separate columns | Excel Worksheet Functions | |||
Convert three separate columns of values to dates | Excel Worksheet Functions |