Dear Kaushik,
Thank you vry much. This approach is helps me and i able to get the answer. However, is there any way that I can straight abstract/setting and the 'not responded' will appear in Worksheet 3? Or i need to manually copy the #N/A to worksheet 3?
Hi Kaushik,
The criteria that I will get is the staff code no. example KL1235, JB2343, IP 2232 and etc.
The data that I have in Worksheet 1 & 2 will be all staff id code no.
Worksheet 1 - main database - that i sent invitation to all the staff email to answer the survey (consist of email &...
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...