+ Reply to Thread
Results 1 to 8 of 8

Excel 2007 : Comparing cells to find best results

  1. #1
    Registered User
    Join Date
    12-21-2008
    Location
    Dupont PA
    Posts
    99

    Comparing cells to find best results

    What can I do to make a "ranking system" for the following sheet I attached.

    Looking to compare all availabletechnicians against themselves on the MONTHLY page.(matrix F10:I34)

    Maybe as simple as changing the #1's text color so its easily spotted.
    Attached Files Attached Files
    Last edited by berk21; 11-05-2009 at 10:55 PM.

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Comparing (technicians) cells to find top 3 best results

    A sample sheet with some actual data and and actual example of your desired results would be easier for us to see what you're after.

  3. #3
    Registered User
    Join Date
    12-21-2008
    Location
    Dupont PA
    Posts
    99

    Re: Comparing (technicians) cells to find top 3 best results

    Sorry...I forgot you to see #'s
    just filling in some to get the idea
    here ya go
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    12-21-2008
    Location
    Dupont PA
    Posts
    99

    Re: Comparing (technicians) cells to find top 3 best results

    just checking back.....

    Is there enough information in the cells to determine my request?

  5. #5
    Registered User
    Join Date
    10-29-2009
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2003,2007
    Posts
    4

    Re: Comparing (technicians) cells to find top 3 best results

    Hi Berk21, IMHO you can choose here to do it using the RANK formula or conditional formatting.
    If you are going to use the second. In excel 2007 first select the range where you want to base your top 3. In your book at the sheet "Monthly Review" select from F10 to F34 then go Home -> Conditional formatting -> New Rule... -> Format only top or bottom ranked values -> at the edit the rule description select the appropriate rank or bottom change the 10 for 3 and select the format you want.

    If you like use the formula Rank just check the attached book.

    Hope you find this helpful.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    12-21-2008
    Location
    Dupont PA
    Posts
    99

    Re: Comparing (technicians) cells to find top 3 best results

    Thank you pedroxido

    Good start..but I was wondering if the top 2 Technicians can be highlighted after the results are ranked as a whole.

    I don't want to highlight the 100% and the 99%'s .....I want the formula to compare ALL the techs final scores and find the 2 that excel past the rest, and their name be colored.

    maybe this is easier to make sense of this:
    pretend the 4 columns are quarters in high school with GPA's...compare all "scores" to get the top 2 in their class.

    The last key thing I need is compare all techs in column C10:C34 as long as there is a name in there...not all the time will there only be 17 techs...maybe 20 next month or 5...so the formula has to recognize the all the techs at any given moment.

    Thank you in advance....

  7. #7
    Registered User
    Join Date
    12-21-2008
    Location
    Dupont PA
    Posts
    99

    Re: Comparing (technicians) cells to find top 3 best results

    Here is the actual October spread sheet...with those numbers in place, I need to "rank" my Technicians.....conditional formatting was nice but not all I was looking for...
    can I possibly set a numerical value adjacent to the correct person?
    ie. Tech A 1st, Tech H 2nd, Tech D 3rd in column J.

    Examples in attachment
    Attached Files Attached Files

  8. #8
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Comparing cells to find best results

    Why not just add a formula in J10 and copy down, =AVERAGE(F10:I10), and sort descending?
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1