Return column number from a table of data

[LettersFromSeneca]

Hi

I have a table of data containing results from a Temperature uniformity survey. I have extracted the highest and lowest temperatures for each row in the table but I also need which column those values are from. I need the column number to return a value between 1-9. So, if the highest value is in A10, I need the formula result to be 1. if the highest value is in B10 , I need the formula result to be 2... ect

 

[Fluff]

Hi & welcome to MrExcel.
You can use xmatch for that like

=xmatch(j10,a10:k10)

where J10 holds the max value for that row.

 

[LettersFromSeneca]

Hi & welcome to MrExcel.
You can use xmatch for that like

=xmatch(j10,a10:k10)

where J10 holds the max value for that row.

Thanks Fluff, that's a great help.

 

[Fluff]

You're welcome & thanks for the feedback.