Forum Discussion
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...
In D2:
=LEFT(RIGHT(LOOKUP(A2&B2&C2&REPT("z",6),H:H),6),3)
In E2:
=RIGHT(LOOKUP(A2&B2&C2&REPT("z",6),H:H),3)
Fill down from D2:E2 to D3:E3.
HansVogelaar Thank you so much for your time, this works perfectly to what I needed! Appreciate your help highly!!!
