Counting/Matching

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

use month in cell date to sum all relevant cells 2
Pivot table 5
Check if date is between two dates, then sum only those rows 2
Excel VBA to match positive and negative transactions 3
VLOOKUP or MATCH and/or INDEX to extract value on a given date 7
Question: How many occurences in date range? 4
Sum, Average, and Count from imported .txt file 2
Array to find relative position - is there a better way? 3

Back
Top