Lawrence
08-18-2008, 05:33 PM
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.
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.