Friday, 6 September 2013

Excel: how many times each value appears in a column?

Excel: how many times each value appears in a column?

I have column with time data like this:
17:27:31
17:27:32
17:27:32
17:27:33
17:27:33
17:27:34
17:27:34
17:27:34
17:27:35
17:27:36
I want to count how many times each time repeats:
17:27:31 1
17:27:32 2
17:27:33 2
17:27:34 3
17:27:35 1
17:27:36 1
How to do such thing?

No comments:

Post a Comment