Duplication probs :(

Originally Posted by colette

Hi All,

Just a quickie I hope, is there anyway of preventing duplicates? What I have is a sheet where out of 3 scores only the highest is used, what I need to know is is there a way of separating in the event of a tie, say for example by taking the 2nd score into account?

Thanx for any help

p.s i've attached the workbook

Colette

Hi,

was this question already answered in your other post?

In the example attachment, the only problem appears to be in the test data which leaves errors from row 42 onwards, which affects the Rank F2:F63

Was something else required?

---