L
Lowell
I have a spread sheet with two columns:
Date St. No.
4/10/06 1452
5/13/06 1339
5/22/06 3538
6/1/06 1452
6/9/06 305
In this example, I have two number “1452â€, however, my spread sheet contains
about 2000 data with numbers ranging from single digits to 5 digits. How can
I have Excel count all of the repeating numbers and providing me the answer.
I don’t want to sort the data because of other issues.
Thanks for any comments.
Date St. No.
4/10/06 1452
5/13/06 1339
5/22/06 3538
6/1/06 1452
6/9/06 305
In this example, I have two number “1452â€, however, my spread sheet contains
about 2000 data with numbers ranging from single digits to 5 digits. How can
I have Excel count all of the repeating numbers and providing me the answer.
I don’t want to sort the data because of other issues.
Thanks for any comments.