+ Reply to Thread
Results 1 to 3 of 3

Maximum value in a range to return a certain word

  1. #1
    Registered User
    Join Date
    08-20-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Maximum value in a range to return a certain word

    I have a range U3:Z3. I want to find the max value of that range and depending which column the max value is in I need to return a certain word in cell AC3.

    So if the max value is in U3, i want to return "Ex" in AC3, if its in V3 then "Mm" in AC3 etc. Is there one formula I can put in AC3 that will do this? Thanks for the help.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,336

    Re: Maximum value in a range to return a certain word

    Hi,

    What's the link between columns U, V, W..etc and "Ex", "Mm", "??" etc.

    Do these text items appear on a different row in columns U:Z?

    If so and assuming row 4 contains the values

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    08-20-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Maximum value in a range to return a certain word

    LOL, this works great! thanks so much

+ 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] Value return from Minimum and Maximum values
    By indira in forum Excel General
    Replies: 3
    Last Post: 09-03-2014, 08:37 PM
  2. Return Heading of Column with Maximum Value
    By eugp87 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-15-2012, 07:44 PM
  3. [SOLVED] Return maximum value, provided two conditions are met.
    By chan069 in forum Excel General
    Replies: 16
    Last Post: 11-22-2012, 08:33 AM
  4. Return Maximum value with Conditions
    By Ore4444 in forum Excel General
    Replies: 7
    Last Post: 07-07-2011, 02:22 AM
  5. Return Maximum value
    By Soapydux in forum Excel General
    Replies: 5
    Last Post: 04-06-2005, 01:06 PM

Tags for this Thread

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