View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam Crump
 
Posts: n/a
Default Return entries from one named range based on the contents of another


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