I have a list of contacts in a named range. In another named ranged i
have the date if one of the contacts has returned a questionnai
Name Questionnaire Returned?
Joe Bloggs 02/02/06
Alan Simple
Billy Carntdo excel
Miffy The Cat 01/03/06
On a seperate sheet I'd like a list (without spaces) of all those who
havent returned their survey yet (i.e. Alan S and Billy Carntdo above).
I'd like this list to update as I enter dates for survey returns.
Is their anyway of doing this, I have been fiddling with CSE formulas
and named range intercepts all morning please help!
--
Sam Crump
------------------------------------------------------------------------
Sam Crump's Profile:
http://www.excelforum.com/member.php...o&userid=32184
View this thread:
http://www.excelforum.com/showthread...hreadid=519343