I Need Help Returning Column Numbers
Do you want the actual column number or the relative column number?
For example:
......J.....K.....L.....M.....N.....
......8.....2.....7......6......1......
Column J has the highest value. Column J's actual column number is 10 but
its relative column number is 1.
--
Biff
Microsoft Excel MVP
"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
|