I have two named ranges. One contains a list of contacts the other contains the date they returned a questionnaire or a blank if they havent,


Name

Joe Blogs
Alan Simple
Billy Carntdo Excel
Miffy The Cat


Questionnaire Returned

02/02/06


03/02/06

I'd like to automatically list, without spaces, all the contacts who are yet to return questionnaires (i.e. Alan Simple and Billy Carntdo from example above).
Is there anyway of doing this, I've been fiddling with CSE formulas and named range intercepts all morning please help!