I Need Help Returning Column Numbers
Lets say in A1 thru K1 we have:
1 2 10 11 9 7 5 3 8 4 6
In another cell enter:
=MATCH(LARGE($A$1:$K$1,ROWS($A$1:A1)),$A$1:$K$1,0)
and copy down to display:
4
3
5
9
6
11
7
10
8
2
1
--
Gary''s Student - gsnu200770
"Cory from Eugene" wrote:
I want to be able to search a row of number, find the largest value (LARGE
function), and then return the Column Number of the cell. I cant quite figure
it out.
Can anyone help?
Thanks,
Cory
|