I have enclosed a sample worksheet where column A contains a list of names. Column C also contains a list of names. I am attempting to create a list of names missing from column C. I am also trying not to use VBA and also making sure there are no duplicate names.
Thank You in advance.
Try this array formula** entered in E2:
=IFERROR(INDEX(A$2:A$161,MATCH(0,IF(ISNA(MATCH(A$2:A$161,C$2:C$82,0)),COUNTIF(E$1:E1,A$2:A$161)),0)),"")
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Copy down until you get blanks.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Works Great!!! Thank you very much.
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks