+ Reply to Thread
Results 1 to 3 of 3

Populate the name of the max value in a range

  1. #1
    Registered User
    Join Date
    07-15-2010
    Location
    Tampa FL
    MS-Off Ver
    Typically Latest Version
    Posts
    12

    Populate the name of the max value in a range

    Hi all, I need some help with this one. See attached.

    Yellow column(A-H) are cycle time values of the steps in a process.
    Green column(I) is a simple max of each yellow row.

    I need some help with the blue columns.

    Column “J” to populate the name of the process (Row 1) that had the maximum value.
    Column "K" to populate the second highest value in the yellow row.
    Column “L” to populate the name of the process (Row 1) that had the second highest value.

    I've manually populated the first few to help clarify what we're looking for. Any help appreciated.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    Win10/MSO2016
    Posts
    13,000

    Re: Populate the name of the max value in a range

    J2:
    Please Login or Register  to view this content.
    k2:
    Please Login or Register  to view this content.
    l2:
    Please Login or Register  to view this content.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    07-15-2010
    Location
    Tampa FL
    MS-Off Ver
    Typically Latest Version
    Posts
    12

    Re: Populate the name of the max value in a range

    Thank You! Worked perfect!!!

+ 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] Trying to populate a cell with value from a range based on criteria in another range
    By themolineux in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-02-2024, 11:50 AM
  2. Replies: 9
    Last Post: 04-02-2024, 04:08 PM
  3. How to populate a range from a range with a specific starting point
    By g_shaw in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-31-2021, 01:18 AM
  4. [SOLVED] VBA code to populate a Range depending on values in another Range
    By Andrevictor in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-06-2021, 06:50 AM
  5. [SOLVED] Populate a range, based on text from another range (VLOOKUP)
    By keith740 in forum Excel General
    Replies: 3
    Last Post: 03-23-2017, 08:08 PM
  6. Populate a cell from a range if between date/time range.
    By joplrw10 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-16-2014, 06:12 AM
  7. [SOLVED] Dynamic Named Range to Auto-Populate another range based on criteria
    By BeachRock in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-24-2014, 06:46 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