Using Collect with the large function

Justin Mauzy

I have 3 columns in the same sheet:

The formula that is in the Case Total/Supervisor is (this works perfectly):

=LARGE([Total Issues]61:[Total Issues]150, 1)

I am trying to do the following:

• I want to collect the name in the row with the Largest value. These are higher up on the sheet.
• Put that name into the Name column.

The formula I am trying to use is:

=INDEX(COLLECT(Name61:Name131, LARGE([Total Issues]61:[Total Issues]131, 1))

Ultimately, I am trying to highlight the top 10 offenders but want it to be dynamic.

Sameer Karkhanis

Use the corrected formula below,

=INDEX(COLLECT(Name61:Name131, [Total Issues]61:[Total Issues]131, LARGE([Total Issues]61:[Total Issues]131, 1)),1)

Sameer Karkhanis

Use the corrected formula below,

=INDEX(COLLECT(Name61:Name131, [Total Issues]61:[Total Issues]131, LARGE([Total Issues]61:[Total Issues]131, 1)),1)

Justin Mauzy

Thank you! That worked perfectly.