View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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