ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Group and count a list of dates (https://www.excelbanter.com/excel-worksheet-functions/156123-group-count-list-dates.html)

Jeffshex

Group and count a list of dates
 
I'm trying to take a list of dates from column E on sheet2 and have them
grouped and count the number of occurances of the dates and list them on
sheet1.
For example on sheet2 would be:

# Description Date
==================
1 Blah blah 8/1/2007
2 Blah blah... 8/1/2007
3 Blah blab 8/9/2007
4 etc... 9/1/2007

And on sheet one it will just say:

Date Count
===========
8/1/2007 2
8/9/2007 1
9/1/2007 1
....and so on.

Any ideas?


All times are GMT +1. The time now is 12:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com