View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default I Need Help Returning Column Numbers

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