Share via

Find Column # of the Max value of a cell range

Anonymous
2019-08-29T18:23:13+00:00

I simply want to have a formula that determines the cell column number of the maximum value in a range that is horizontal.   For example, I can use max(A2:A100) to find the maximum VALUE of a cell, but how do I create a formula that returns the column NUMBER of that maximum value?

I tried several ideas, but none work.   For example, cell("col",max(A2:100)) does not work, as several other methods I tried do not.

I'm using excel 2010, my OS is windows 7 professional.

thank you for any ideas/help,

Vince

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2019-08-29T18:34:30+00:00

Hi,

Below is an example to return position, if you want to return column number, just add a number. For example, to return column number of max(A2:A100)

=MATCH(MAX(A2:A100),A2:A100,0)+1

Was this answer helpful?

9 people found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-08-29T19:16:02+00:00

    ok I think this will work for me, thank you!

    Was this answer helpful?

    0 comments