Ar an 29/9/07 21:45, scríobh T. Valko:

Try this.

Assume data starts in row 2, A2:B15.

Enter Q in C2. This person will always be qualified since they are first in
the list.

Enter this formula in C3 and copy down to C15:

=IF(COUNTIF(B$2:B3,B3)2,"",IF(COUNTIF(C$2:C2,"Q") <8,"Q",IF(COUNTIF(C$2:C2,"R"
)<2,"R","")))


Excellent - that did it - (why didn't I think of statically assigning the
1st place!) Many thanks.

Tim