View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\)[_86_] Rick Rothstein \(MVP - VB\)[_86_] is offline
external usenet poster
 
Posts: 1
Default I Need Help Returning Column Numbers

Assuming Row 1....

=MATCH(MAX(1:1),1:1,0)

If it were Row 3...

=MATCH(MAX(3:3),3:3,0)

Rick


"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