From PM
Is it possible to have the value in C6 display the column value where the min rate was located?
After much thought and coming close to declaring it beyond me I came up with a solution - but you may not like it. It involves a helper column (I used M) which can be hidden.
I also CUT the formula from C6 and pasted it in C4 - you can paste it anywhere you want - maybe near top of column M so it can be hidden with the helper column.
Now place this formula in the now vacant C6:
And in the helper column M place this formula in cell M39 (and drag all the way down to M3984):
Give it a try and let me know (in this thread as opposed to PM).
Bookmarks