Displaying column heading information based on a search result.

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
It works perfectly. Thank you!

Bernie Deitrick said:
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
Click to expand...
 
Back
Top