Advanced Excel LARGE Function tie breaker - REPOST Bounty ASAP

Advanced Excel LARGE Function tie breaker - REPOST Bounty ASAP

Closed - This job posting has been filled and work has been completed.

Job Description

Can anyone solve key issue with tie using LARGE function. Proposed solution using existing formula with the addition of a tiebreaker column.

Option 1: Compare data column and tie breaker column

Option 2: Formula adds data column with tie breaker column and compares

See attached...Which ever can generate the simplest formula

Please contact me immediately if you can solve this with simplest formula possible.


Task: Enable solution to handle ties. The current solution to original post below uses the LARGE function which repeats found large value when there is a tie.

(Low Priority) Also I would like to eliminate the display of #NUM and #NA in the results.

See current solution attached
Today (ASAP) is due date- please let me know how soon you can delivery.

INITIAL TASK: Build a Top 10 list on multiple sort options from larger list

A. Build 7 Top 10 list using formulas based on largest value in 7 columns. See

Both A and B return the entire row row of each rank.
Do not use following: IFERROR, Macros, vlookup, array requiring (Ctrl+Shift+Enter), Pivot table, Functions should be support in Excel 2003

Likely result found using functions like (Large, Rank, Index, Match, CountIf.
Also trap for blanks - less than 10 records.

Please propose solution. Will retain as future resource.

Open Attachment

Other open jobs by this client