First Post, thanks in advance for help.
I'm puzzled by this task and cant work around it.
Looking for a way to find a MIN number to the right of a MAX number in a list.
List will always change so the whole list needs considered.
Thanks
MINMAXEX.jpg
First Post, thanks in advance for help.
I'm puzzled by this task and cant work around it.
Looking for a way to find a MIN number to the right of a MAX number in a list.
List will always change so the whole list needs considered.
Thanks
MINMAXEX.jpg
Perhaps
=MIN(INDEX(1:1,,match(B2,1:1,0)+1):XFD1)
in B3
Don
Please remember to mark your thread 'Solved' when appropriate.
That did it!
Thank you very much!
. .
For future info, what is the :XFD1 represent?
Thanks. ( last in row Got it! )
Last edited by RidgeRunner; 03-22-2018 at 08:48 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks