Displaying column heading information based on a search result.

[Guest]

I am currently using the MAX command to find a maximum value within 96
columns per row.

I display the result in a column to the left of the 96 columns containing
the searchable data.

What I would like to do is display the column heading label (time increments
shown per 15 minutes {i.e., 12:15 AM}) in the column next to the MAX search
result.

Column A: MAX search result
Column B: Column heading where MAX search result was found
Column C: Date
Column D-CV: Searchable data

This report contains about 500 rows, so it’s not as simple as manually
entering the column heading label for each MAX search result.

I hope I’m explaining this clearly enough.

Thanks again in advance.

 

[Bernie Deitrick]

Me,

Format cell B2 for time, then use this formula in cell B2:

=INDEX(D1:CV1,MATCH(MAX(D2:CV2),D2:CV2,FALSE))

HTH,
Bernie
MS Excel MVP

 

[Guest]

It works perfectly. Thank you!

Me,

Format cell B2 for time, then use this formula in cell B2:

=INDEX(D1:CV1,MATCH(MAX(D2:CV2),D2:CV2,FALSE))

HTH,
Bernie
MS Excel MVP