ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Get count for a table of dates (https://www.excelbanter.com/excel-worksheet-functions/117054-get-count-table-dates.html)

[email protected]

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


[email protected]

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