PDA

View Full Version : EXCEL question



BuckeyeRedleg
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.

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

http://support.microsoft.com/?kbid=823573

BuckeyeRedleg
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.

RedsManRick
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...

WebScorpion
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: