![]() |
Get count for a table of dates
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 |
Get count for a table of dates
Easiest solution would be to use a pivot table (data menu)
wrote: 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 |
All times are GMT +1. The time now is 10:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com