Solved: Ranking Data in List

[Lawrence]

Attached is a condensed version of my workbook (columns B & C). I then inserted column A to rank the employees. From there, I have the Top 10 and Bottom 10 Performers tables.

In the Top 10 and Bottom 10 tables, I would like to omit names that have a comma followed by a title.

For instance, in the Top 10 table, "Employee 18,SUPERVISOR" and "Employee 43,VP" would be skipped and replaced by the next one down, yielding to the table in L5:M14.

[Bob Phillips]

=OFFSET(B$2,MATCH(SMALL(IF((NOT(ISNUMBER(FIND(",",$B$2:$B$4331))))*($A$2:$A$4331<>""),$A$2:$A$4331,FALSE),ROW()-ROW($H$5)+1),$A$2:$A$4331,0)-1,0)

as an array formula

[Lawrence]

Thank you Bob.