Hi,
I'm trying to return the cell reference of a value gotten from an array with the Large() formula. I'm talking about the reference of that number within the array. So for example, say the 3rd largest value within the range is 45 - I want to be able to pull back the fact that that value is in cell B4 within that array.
The Large() Formula in question is:
Can anybody think of a way to do this? I've tried fiddling around with Address(), but can't think of an intelligent way to get the row or column numbers.=LARGE(Sheet2!$B$3:$H$24, $H21)
Any help much appreciated.
Best,
S
Bookmarks