ExcelBanter - Return entries from one named range based on the contents of another

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Return entries from one named range based on the contents of another (https://www.excelbanter.com/excel-worksheet-functions/75499-return-entries-one-named-range-based-contents-another.html)

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

Return entries from one named range based on the contents of anoth

I would just use the Data Filter AutoFilter feature and select Custom
from the date column and enter "greater than" 0
It will filter all those with a name and a date..........
To return to normal, just do Data Filter Sutofilter again.....it's a
toggle

Vaya con Dios,
Chuck, CABGx3

"Sam Crump" wrote:

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