Get count for a table of dates

  • Thread starter Thread starter murzik
  • Start date Start date
M

murzik

Hello,

I have a table of dates that I need a count for. There is approximately
10,000 dates. some of them repeating. I need a count per day. So if
10/31/06 shows up six times it would write it to a seperate column as
10/31/06 6.

Thank you in advance

-Mur
 
Easiest solution would be to use a pivot table (data menu)
 
You must log in or register to reply here.

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

formula for multiple criteria inc. date range 4
Counting problem 3
IF Dates 1
Counting dates within a range 1
Counting Occurrence of a Value within Cells 1
Pivot Table showing wrong data 1
conditional sum query 1
count dates 4

Back
Top