Extract column label based on MAX and MIN values

Hi
Any ideas as to how can i extract the column label for the MAXs and MINs. It's crucial to extract the label names of ALL columns that scored the maximum value (or minimum).
For instance Cell I2 shows V, SS because those two columns contain the MAX scores in the range (similar for MIN.. R, CI).
The actual data contains several hundred rows and the data is grouped in 3 rows per person.
Luis

What are the Max and Mins based on?

I can't match your results, what am I missing?

See Attached

Luis, you might want to consider a User Defined Function (VBA) for this

Please Login or Register  to view this content.

the above, stored in a module, would be called from a cell along the lines of:

Please Login or Register  to view this content.

the above is designed to account for possibility that "persons" may not always be listed in a contiguous range within the first criteria range

Hi Don, you've beaten me to it once again! I'll get this formula thing one day!

For what it's worth luis33, here's my tuppence worth using helper columns and formulae.

1/. In A2

Please Login or Register  to view this content.

Drag Down as required.

2/. In I2

Please Login or Register  to view this content.

Drag Across to M2.

3/. In O2

Please Login or Register  to view this content.

Drag Across to S2.

4/. In U2

Please Login or Register  to view this content.

Drag Across to V2.

5/. In X2

Please Login or Register  to view this content.

Drag Across to Y2.

6/. Drag all Formulae Down as required.

Important
I have added a column to enter actual names.
Don't delete column A, or column B, and don't add any more columns before column H

Use the grouping buttons to hide/show columns to step through the steps, and hide the columns to clearly see the results.

Hope this helps

On behalf of all, glad to have been of help.