#1
|
|||
|
|||
look up and display last max value in a column
Good day Excel experts. I have attached an example spreadsheet. It is a spreadsseet I intend to update daily with the date being column A, and a given numerical value in column B. What I want to do here is have the spreadhseet display in cell E5, the LAST maximum value in column B, and the corresponding date of that value in cell G5. Obviously using "=max(b:b)" in cell E5 will return the value 50 as this is the maximum numerical value in column B, but I want the spreadsheet to look up and display in cell E5, the last maximum value in column B,which in my example spreadsheet can be found in cell B15, or 26. Then I want to know what formula to use in cell G5 to return the date when this value occured, or 2024-01-11, as in cell A15. Then each day as the list is updated, I want the values in cell E5 and G5 to recalculate and display the last occurring maximum value that is in column B, based on the date, so it should look back and find the previous date with the maximum value of column B and display that If the current cell on a given date is equal to or already the maximum value in column B, then display that value and date in E5 and G5. Please let me know if any questions, and thanks for your help and suggestions |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Display of predecessor and successor column | tropaj | Project | 3 | 04-03-2022 04:12 PM |
display a change in column cells counting the number of months | oscarlimerick | Excel | 4 | 03-14-2022 12:22 AM |
Display an additional date column in Gantt chart | ds1 | Project | 4 | 04-17-2017 01:34 PM |
Embedded Excel in Powerpoint - custom animation, display column by column | andytheanimal | PowerPoint | 2 | 01-20-2015 06:30 AM |
Excel Fomula to search for a string and display value from different column | zeeshanbutt | Excel | 1 | 07-29-2012 12:48 AM |