ExcelBanter - cell column number for the max value of a range of numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - cell column number for the max value of a range of numbers (https://www.excelbanter.com/excel-discussion-misc-queries/131806-cell-column-number-max-value-range-numbers.html)

Aline

cell column number for the max value of a range of numbers

i have tried to use the column function to get the column number for the max
value of a range of numbers but it didn't work. i know that a solution for
this exist but i have tried different ways and in vain. any ideas?!

David Biddulph

cell column number for the max value of a range of numbers

One way would be
=MATCH(MAX(A1:D1),A1:D1)-1+COLUMN(A1)
--
David Biddulph

"Aline" wrote in message
...
i have tried to use the column function to get the column number for the
max
value of a range of numbers but it didn't work. i know that a solution for
this exist but i have tried different ways and in vain. any ideas?!

All times are GMT +1. The time now is 08:14 AM.