ExcelBanter - Column Index

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Column Index (https://www.excelbanter.com/excel-worksheet-functions/6201-column-index.html)

Megan

Column Index

Hello,
It seems simple, and I have seen this before, but I have not been able to
weed through the threads to find it.....
I need to find the column index forthe max of A1:Z1
Thanks!

Frank Kabel

Hi
=MATCH(MAX(A1:Z1),A1:Z1,0)

"Megan" wrote:

Hello,
It seems simple, and I have seen this before, but I have not been able to
weed through the threads to find it.....
I need to find the column index forthe max of A1:Z1
Thanks!

Meg

Worked great thanks!

"Frank Kabel" wrote:

Hi
=MATCH(MAX(A1:Z1),A1:Z1,0)

"Megan" wrote:

Hello,
It seems simple, and I have seen this before, but I have not been able to
weed through the threads to find it.....
I need to find the column index forthe max of A1:Z1
Thanks!

All times are GMT +1. The time now is 03:48 PM.