+ Reply to Thread
Results 1 to 2 of 2

find the max value of each subset and display corresponding cell value from another column

  1. #1
    Registered User
    Join Date
    03-13-2016
    Location
    chennai, india
    MS-Off Ver
    2010
    Posts
    1

    find the max value of each subset and display corresponding cell value from another column

    Hi,

    Need some help. i have list with three columns

    col1 has some text
    col2 has dates
    col 3 has a number

    i want to find the max value for each day and return corresponding value from column 1. how can this be done?

    thanks in advance.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,422

    Re: find the max value of each subset and display corresponding cell value from another co

    Welcome to the forum.
    Without an uploaded file I'll have to go with how I feel the data appears. To return the corresponding value I have added 2 helper columns, both of which could be hidden for aesthetic purposes if desired. The first helper column would find the max value by date. The second gives the corresponding value from column 1, however it leaves blanks for cells that are not in the same row as the max value. There is a third column that gives the corresponding values from column 1 as a list. The formulas for these three columns, respectively, are:
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    The first and third formulas are array formulas which must be activated by holding the Ctrl and Shift keys while pressing Enter.
    Here is a file with the formulas applied to data that matches the description from post #1: Max Value by Date.xlsx
    Let me know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Replies: 0
    Last Post: 04-25-2015, 01:14 AM
  2. [SOLVED] Find MAX in range and display value of the top cell in column
    By Templemind in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-01-2014, 10:32 AM
  3. [SOLVED] Find value in column, and display ajacent cell
    By Chris.Fadden in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-24-2013, 12:04 PM
  4. Replies: 5
    Last Post: 10-08-2012, 05:42 AM
  5. [SOLVED] HOW? Find and display the last cell in a column with a value > 0
    By Conker10382 in forum Excel General
    Replies: 10
    Last Post: 07-21-2006, 09:05 PM
  6. How to enter symbols for subset or element of a subset in Excel?
    By rwcita in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-23-2006, 05:30 PM
  7. [SOLVED] Best way to display a subset of data in a web page
    By TC in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-08-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