View Full Version : EXCEL question

07-10-2008, 12:23 PM
I have a spreadsheet with 7500+ rows of data. In one of the columns, it lists cities, but they repeat many times. Is there a way to highlight that particular column and determine how many DIFFERENT cities there are in the 7500 rows of data.

The spreadsheet is already sorted by that column (city) and I guess I could scroll down and hand count it but I know there is an easier way to do it but I can't remember.

Any help would be appreciated because eventually there will be nine spreadsheets totalling 65,000 rows and I don't need all that information.

07-10-2008, 12:26 PM
This might help.


07-10-2008, 01:03 PM
Awesome. Thanks, Rick.

I combined three of the lists (23,000) rows and plugged in the formula. Although it timed out on me the first time (not responding), it eventually got it. It took nearly a minute for excel to figure it out, but it seems to have worked.

07-10-2008, 01:10 PM
Google is definitely your friend when it comes to Excel questions/problem. I've found many a useful formula in my time cleaning data...

07-11-2008, 09:18 AM
This is just one more reason this place is great. Ask any question and the odds are someone here can and will say something helpful. Thanks RMR! :thumbup: