Turn Off Ads?
Results 1 to 5 of 5

Thread: EXCEL question

Hybrid View

  1. #1
    Will post for food BuckeyeRedleg's Avatar
    Join Date
    Oct 2001
    Location
    Dublin, OH
    Posts
    5,346

    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.

  2. #2
    Stat Wanker Hodiernus RedsManRick's Avatar
    Join Date
    Dec 2004
    Location
    Chicago, IL
    Posts
    16,003

    Re: EXCEL question

    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.

  3. #3
    Will post for food BuckeyeRedleg's Avatar
    Join Date
    Oct 2001
    Location
    Dublin, OH
    Posts
    5,346

    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.

  4. #4
    Stat Wanker Hodiernus RedsManRick's Avatar
    Join Date
    Dec 2004
    Location
    Chicago, IL
    Posts
    16,003

    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.

  5. #5
    SERP deep cover ops WebScorpion's Avatar
    Join Date
    Apr 2000
    Location
    In the Ether
    Posts
    5,401

    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!

    "Okay you guys, pair up in threes!" --Yogi Berra


Turn Off Ads?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Board Moderators may, at their discretion and judgment, delete and/or edit any messages that violate any of the following guidelines: 1. Explicit references to alleged illegal or unlawful acts. 2. Graphic sexual descriptions. 3. Racial or ethnic slurs. 4. Use of edgy language (including masked profanity). 5. Direct personal attacks, flames, fights, trolling, baiting, name-calling, general nuisance, excessive player criticism or anything along those lines. 6. Posting spam. 7. Each person may have only one user account. It is fine to be critical here - that's what this board is for. But let's not beat a subject or a player to death, please.

Thank you, and most importantly, enjoy yourselves!


RedsZone.com is a privately owned website and is not affiliated with the Cincinnati Reds or Major League Baseball


Contact us: Boss | GIK | BCubb2003 | dabvu2498 | Gallen5862 | LexRedsFan | Plus Plus | RedlegJake | redsfan1995 | The Operator | Tommyjohn25