View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Cory from Eugene[_2_] Cory from Eugene[_2_] is offline
external usenet poster
 
Posts: 14
Default I Need Help Returning Column Numbers

I really cant use that. I tried. Any other suggestions?

"Ron Coderre" wrote:

Try something like this:

=MATCH(LARGE(A1:Z1,1),A1:Z1,0)

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Cory from Eugene" wrote in
message ...
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