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


"Me" <(E-Mail Removed)> wrote in message
news:1A8D5FD7-1617-442F-B01D-(E-Mail Removed)...
>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.

It works perfectly. Thank you!

"Bernie Deitrick" wrote:

> 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
>
>
> "Me" <(E-Mail Removed)> wrote in message
> news:1A8D5FD7-1617-442F-B01D-(E-Mail Removed)...
> >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.
>
>
>