I'd like to share.....VLOOKUP + Filter

[James Perry]

Cell A1 has the label 'email of those invited'
Cell B2 has the label - RSVP'd
Cell C2 has the label - Not RSVP'd
Cells B2:B25 contain the email addresses of those invited who have RSVP'd
Required-
Cells C2:C25 to display only those who have not RSVP'd
My solution:
In cell C2 enter the formula -
= VLOOKUP(B2,A:A,1,FALSE)
Double click or drag down formula as required.
Cells C2:C25 will display......
1. emails of those who have RSVP'd
&
2. #N/A for those who have not RSVP'd
Next, do as FILTER on cell C2 by #N/A, after which column A will show only the email
addresses of those who have not RSVP'd
And column C will display #N/A (as applicable)

Thank u and #HAPPY2015

 

[Somendra Misra]

Hi James,

First of all New Year Wishes to you and to your family.

Secondly, it's always help other's if you attach a sample file with the working of what you have done or found. So would ask you to attach a file.

Regards,