I Need Help Returning Column Numbers
Try something like this:
=INDEX(COLUMN(J1:N1),MATCH(MAX(J1:N1),J1:N1,0))
If there are duplicate max values the formula will "find" the first instance
only.
--
Biff
Microsoft Excel MVP
"Cory from Eugene" wrote in
message ...
i need actual column number
Thanks,
Cory
"T. Valko" wrote:
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
|