How to break ties in Rank by specified criteria?

D

dpeck

My spreadsheet has four columns and nine rows:

(Kennel Pts. A2) (PP Pts., B2) (Kenenl Rank C2) (PP Rank D2)

Kennels are ranked by "Rank(a2,a$2:a$9) in C2. Ties are eliminated by adding:

+countif(a$2:a2,a3) to the "Rank" formula starting on row A3 down thru A9.

Ties are decieded in favor of the entry appearing first on the list A2:A9.

I want to settle ties on the basis of highest ranked PP, but only want the
TIED items affected by their related PP rank, not the untied kennels too.

Any help is appreciated,

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use RANK to break multiple ties. 1
How to code it in macro? 0
How to code it in macro? 2
How to divide numbers in Excel? 0
How to Use Relative Reference in Array Formula 4
I want to align two columns by using insert/shift down 0
formula help to get oldest date in column based off another parameter 0
How to use SUMIF to return sums between two values located in cells 1

Top