Keeping Specific Rows in Excel According to a Guide -

let's have sheet this:

               b           c                       d employee id   last name  first name   employees working on project 10001           aaa        bbb                     10004 10002           mmm        nnn                     10006 10003           yyy        zzz                     10009 10004           uuu        xxx                     10010 10005           fff        ggg 10007           kkk        hhh 10009           rrr        ppp 

i want isolate employees working on project , delete rest of rows. however, of isolated ids, keep rows b , c. idea how without having manually?

i insert column after column c formula like

=iserror(match(a2,$e$2:$e$5,0)) 

will return true if working on project a, false otherwise

you can filter or sort on column