Forum Discussion

ashtar123's avatar
ashtar123
Copper Contributor
Feb 11, 2023

Let Excel recommend the largest current value among a series of data? Please help!!!

Hi Excel experts, Would you be able to kindly help with setting up a formula or VBA (whichever is simple) to catch the largest current value of a series of values? Please see attached work file...
excel
Formulas and Functions
Macros and VBA
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Feb 11, 2023

ashtar123 

=MID(INDEX($H$2:$H$11,LARGE(IF((LEFT($H$2:$H$11,3)=A2)*(NUMBERVALUE(MID($H$2:$H$11,4,4))=B2)*(MID($H$2:$H$11,8,3)=C2),ROW($H$2:$H$11)-1),1)),11,3)

Another solution could be this formula in cell D2. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.

=RIGHT(INDEX($H$2:$H$11,LARGE(IF((LEFT($H$2:$H$11,3)=A2)*(NUMBERVALUE(MID($H$2:$H$11,4,4))=B2)*(MID($H$2:$H$11,8,3)=C2),ROW($H$2:$H$11)-1),1)),3)

This formula is in cell E2. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.

 

 

  • ashtar123's avatar
    ashtar123
    Copper Contributor
    Feb 13, 2023
    Thank you so much for your time, this works perfectly to what I needed!

Resources