Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting/Matching
I have three columns of data: date, transaction code, quantity. A date can
have multiple rows of data I need to count the number of rows (transactions) there are per each date. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting/Matching
The easiest way to do this is with AutoFilter and use subtotal function with
count . Lookup both in help. I find when using autofilter and subtotal, placing the column headers down a few rows say row 5 and freezing panes so the first 5 rows including the column headers are always displayed. You can then place subtotal function above the column headers and they are always visible. You then have only to set the filter to the required date and you have your counts. Note if you use the method described above, you may have select the column headers before applying autofilter to ensure they set correctly. Regards, OssieMac "Anna" wrote: I have three columns of data: date, transaction code, quantity. A date can have multiple rows of data I need to count the number of rows (transactions) there are per each date. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting/Matching
It worked just like I wanted. Thanks for the help.
"OssieMac" wrote: The easiest way to do this is with AutoFilter and use subtotal function with count . Lookup both in help. I find when using autofilter and subtotal, placing the column headers down a few rows say row 5 and freezing panes so the first 5 rows including the column headers are always displayed. You can then place subtotal function above the column headers and they are always visible. You then have only to set the filter to the required date and you have your counts. Note if you use the method described above, you may have select the column headers before applying autofilter to ensure they set correctly. Regards, OssieMac "Anna" wrote: I have three columns of data: date, transaction code, quantity. A date can have multiple rows of data I need to count the number of rows (transactions) there are per each date. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Matching Text Fields - Then Moving the Matching Cells Side by Side | Excel Discussion (Misc queries) | |||
Counting & Matching Text | Excel Discussion (Misc queries) | |||
counting unique values and matching to quantities | Excel Worksheet Functions | |||
counting and matching | Excel Worksheet Functions | |||
Matching data and linking it to the matching cell | Links and Linking in Excel |