counting repeat numbers in a column
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 dont want to sort the data because of other issues.
Thanks for any comments.
--
Lowell Shoaf
Realtor
RE/MAX Gulfstream Realty
Sarasota, Florida
|