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
|