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...
Hans formula is perfect if you always search for the last entry. If the largest entry is not the last one, it does not work. You could use my solution for this.
D2=
=LET(in,FILTER(H$2:H$11,ISNUMBER(FIND(A2&B2&C2,H$2:H$11))),TEXT(MAX(VALUE(LEFT(TEXTAFTER(in,C2),3))),"000"))E2=
=LET(in,FILTER(H$2:H$11,ISNUMBER(FIND(A2&B2&C2&D2,H$2:H$11))),TEXT(MAX(VALUE(RIGHT(in,3))),"000"))
Thank you so much for your time, this works perfectly to what I needed! Appreciate your help highly!!!