| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dynamic summed range based on a variable | Excel Worksheet Functions | |||
| Identify the contents of column in a filtered range | Excel Worksheet Functions | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
| How to dynamically reference a dynamic named range | Excel Worksheet Functions | |||
| if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
Linear Mode
