Advanced Excel LARGE Function tie breaker - REPOST Bounty ASAP

Closed - This job posting has been filled and work has been completed.
Web, Mobile & Software Dev Scripts & Utilities Posted 2 years ago

Fixed Price

Delivery by November 15, 2013




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.

About the Client

(4.85) 52 reviews

United States
Duluth 11:19 PM

153 Jobs Posted
51% Hire Rate, 1 Open Job

Over $20,000 Total Spent
106 Hires, 13 Active

$12.36/hr Avg Hourly Rate Paid
838 Hours

Member Since Nov 6, 2009