RedsZone.com - Cincinnati Reds Fans' Home for Baseball Discussion EXCEL question

 07-10-2008, 01:23 PM #1 BuckeyeRedleg Will post for food     Join Date: Oct 2001 Location: Dublin, OH Posts: 5,293 EXCEL question 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, 01:26 PM #2 RedsManRick Stat Wanker Hodiernus     Join Date: Dec 2004 Location: Chicago, IL Posts: 15,427 Re: EXCEL question This might help. http://support.microsoft.com/?kbid=823573 __________________ Games are won on run differential -- scoring more than your opponent. Runs are runs, scored or prevented they all count the same. Worry about scoring more and allowing fewer, not which positions contribute to which side of the equation or how "consistent" you are at your current level of performance.
 07-10-2008, 02:03 PM #3 BuckeyeRedleg Will post for food     Join Date: Oct 2001 Location: Dublin, OH Posts: 5,293 Re: EXCEL question 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, 02:10 PM #4 RedsManRick Stat Wanker Hodiernus     Join Date: Dec 2004 Location: Chicago, IL Posts: 15,427 Re: EXCEL question Google is definitely your friend when it comes to Excel questions/problem. I've found many a useful formula in my time cleaning data... __________________ Games are won on run differential -- scoring more than your opponent. Runs are runs, scored or prevented they all count the same. Worry about scoring more and allowing fewer, not which positions contribute to which side of the equation or how "consistent" you are at your current level of performance.
 07-11-2008, 10:18 AM #5 WebScorpion SERP deep cover ops     Join Date: Apr 2000 Location: In the Ether Posts: 5,373 Re: EXCEL question 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! __________________ "It doesn't get any better than this," --Marty Brennaman

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Forum Rules
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home RedsZone     The Old Red Guard     Game Threads Baseball     The Sun Deck         Game Threads     Minor League Talk Miscellaneous     Introductions and Site Feedback         RedsZone Pictures     Non-Sports Chatter         Politics and Religion Talk         Arts & Entertainment     The Tavern         Fantasy Island Archives     The Archives     Predictions Archives

All times are GMT -4. The time now is 07:07 PM.

 -- RedsZone -- Black RedsZone -- Reds Away Contact Us - RedsZone.com - Archive - Top