# Return LARGE with tiebreakers and title from result

1. ## Return LARGE with tiebreakers and title from result

Hello,

I hope this makes sense.

I am trying to return the LARGE numbers from an array while keeping tiebreaker results in tact and moving onto the next result.

Here are the formulas that seem to work but I am having trouble with the tiebreakers.

This array returns the LARGE result and moves on to the next result even if duplicate. Seems to work but I'm having a hard time validating.

Formula:
`Please Login or Register  to view this content.`

This array returns the header title for the LARGE result. Does not return the correct header.

Formula:
`Please Login or Register  to view this content.`

Following is a sample spreadsheet of how the data looks.

Thank you!

2. ## Re: Return LARGE with tiebreakers and title from result

Your formulae do not tally with your data or your data layout,. Can you re-check and re-post?

3. ## Re: Return LARGE with tiebreakers and title from result

Attached is the revised spreadsheet with the formula arrays included.

As you can see my tiebreakers don't return the correct header title.

Cheers!

4. ## Re: Return LARGE with tiebreakers and title from result

This solution makes use of a helper table B7:H10, which could be hidden for aesthetic purposes, that utilizes the formula:
Formula:
`Please Login or Register  to view this content.`
The most objects table is then populated using the formula:
Formula:
`Please Login or Register  to view this content.`
The header name table is then populated using the formula:
Formula:
`Please Login or Register  to view this content.`
Let me know if you have any questions.

5. ## Re: Return LARGE with tiebreakers and title from result

Or this array formula in O2, copied across & down, with no helper column:

=IFERROR(INDEX(\$B\$1:\$H\$1,SMALL(IF(\$B2:\$H2=J2,COLUMN(\$B2:\$H2)-1,""),1+COUNTIF(\$I\$2:I2,J2))),"")

Array Formulae are a little different from ordinary formulas in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.

You will know the array is active when you see curly braces { } appear around the outside of your formula. If you do not CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.

Don't type the curly braces yourself - it won't work...

6. ## Re: Return LARGE with tiebreakers and title from result

Thank you gents! Both solutions seem to work.

7. ## Re: Return LARGE with tiebreakers and title from result

You're welcome and thanks for the Reputation.

8. ## Re: Return LARGE with tiebreakers and title from result

For Excel 2010+ offers a simpler option.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1