I a master data <sheet 1> (consists of 3000 people, and unique code is the staff ID). I will send out email to all of them to get their respond. I will have a software for the survey and will get back the data on who has responded <sheet 2>.
Now I need to produce a list of people who haven't responded to the survey <sheet 3>. How can I extract this data <sheet 3>? any easy and fast way in MS Excel? thanks a lot.
Now I need to produce a list of people who haven't responded to the survey <sheet 3>. How can I extract this data <sheet 3>? any easy and fast way in MS Excel? thanks a lot.