+ Reply to Thread
Results 1 to 4 of 4

Excel 2010 ... I need to high the highest, second highest & third highest values in column

  1. #1
    Registered User
    Join Date
    06-09-2016
    Location
    Dover, OH
    MS-Off Ver
    Office 2010
    Posts
    1

    Excel 2010 ... I need to high the highest, second highest & third highest values in column

    I have a column tracking sales for 30 sales reps and the values will change daily. As we enter in the sales I would like that column with the totals to change background color for cell based on first, second and third highest totals. I have worked with conditional formatted before and found how to do this in Excel 2003 but we have 2010 now and the conditional formatting is totally different and I can't figure out how to do it in this version.

    Can someone walk me through doing this please?

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    17,820

    Re: Excel 2010 ... I need to high the highest, second highest & third highest values in co

    CF formula

    =A1=LARGE(A1:A1000,1) for highest

    =A1=LARGE(A1:A1000,2) for 2nd highest

    Select A1 or first cell in your range,

    CF ==> "Use a formula ...." enter first formula above==>FILL==>colour

    Set Applies to required range e.g A1:A1000

    repeat for other formulae

  3. #3
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Excel 2010 ... I need to high the highest, second highest & third highest values in co

    Need to lock those ranges

    =A1=LARGE($A$1:$A$1000,1) for highest

    =A1=LARGE($A$1:$A$1000,2) for 2nd highest

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    17,820

    Re: Excel 2010 ... I need to high the highest, second highest & third highest values in co

    @jonmo1..... Thanks ... careless by me!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Max formula to return total of highest, second highest and third highest value
    By JonWilf in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-06-2016, 08:20 AM
  2. Find Sequential Highest High, Lowest Low values
    By analystbank in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-23-2015, 01:18 AM
  3. Replies: 2
    Last Post: 04-27-2015, 04:24 AM
  4. VBA code to find highest and 2nd highest number based in criteria
    By Michael007 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-25-2011, 08:38 AM
  5. Search column for highest value, then second highest, etc.
    By MDPlanner in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-24-2010, 10:39 AM
  6. Picking the highest value from a column and then the next highest
    By johnb28 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-23-2008, 01:20 PM
  7. Replies: 3
    Last Post: 08-10-2006, 11:40 PM

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