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.
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.
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.
The first and third formulas are array formulas which must be activated by holding the Ctrl and Shift keys while pressing Enter.Please Login or Register to view this content.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks