Location of a the second biggest number in a range
=MATCH(LARGE(A1:Z1,2),A1:Z1)
"Josh G" wrote:
I'm trying to find the cell location of the second biggest and third biggest
values in a range. I can find the values themselves with the LARGE formula,
but I haven't been able to figure out how to get the location. Any help
would be appreciated.
|