johannordgren

New Member
Joined
Apr 24, 2018
Messages
30
Hello there!

This question seems really stup, but I can't seem to figure it out, and I actually don't find a thread about it..

I want to count the times each date is recorded in a column.
Ex:
2018-05-21: 15 times
etc.

Thanks in advance!

The column looks like this:
Dates
2018-05-21
2018-05-21
2018-05-21
2018-05-21
2018-05-21
2018-05-21
2018-05-21
2018-05-21
2018-05-21
2018-05-21
2018-05-21
2018-05-21
2018-05-21
2018-05-19
2018-05-19
2018-05-19
2018-05-19
2018-05-19
2018-05-19
2018-05-19
2018-05-19
2018-05-19
2018-05-19
2018-05-18
2018-05-18
2018-05-18
2018-05-18
2018-05-18
2018-05-18
2018-05-18
2018-05-18
2018-05-18

<tbody>
</tbody><colgroup><col></colgroup>
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

WaterGypsy

Well-known Member
Joined
Jan 15, 2010
Messages
697
Have you tried a pivot table?
Or you could put a COUNTIFS formula in the adjacent column
 

Watch MrExcel Video

Forum statistics

Threads
1,109,072
Messages
5,526,640
Members
409,713
Latest member
roman9980

This Week's Hot Topics

Top