OK i need a little help, I'm still new to excel:
on sheet1, column A i have a list of employees in column B i have "Y" if they sent in there paperwork, "I" if it was incomplete and blank if i haven't received it yet:
i want on a separate sheet (sheet2) in the same workbook to populate a list of the names of people who i haven't received the paperwork yet and another list of the name of the people who's paperwork is incomplete. please help and thank you in advance.
on sheet1, column A i have a list of employees in column B i have "Y" if they sent in there paperwork, "I" if it was incomplete and blank if i haven't received it yet:
Name | Paperwork |
John Doe | Y |
Jane Dow | Y |
Micheal Smith | I |
Cinderella Dream | |
Snow White | I |
Jane Smith | |
John Smith | Y |
Susie Smith | I |
i want on a separate sheet (sheet2) in the same workbook to populate a list of the names of people who i haven't received the paperwork yet and another list of the name of the people who's paperwork is incomplete. please help and thank you in advance.