| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to search for given term, and if not found in column to add it to list
You can't get a formula to "push" a value to another cell, so you could
not automatically add a missing item to the list - you will need VBA for that. Hope this helps. Pete financier wrote: Thanks, I'll look into that. Any other ideas folks? I got the first half down using a formula, to find that a symbol is there using MATCH, but the rest I"m clueless on... -- financier ------------------------------------------------------------------------ financier's Profile: http://www.excelforum.com/member.php...o&userid=36260 View this thread: http://www.excelforum.com/showthread...hreadid=560523 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| After 2 days of frustration...Formula | Excel Discussion (Misc queries) | |||
| searching a large database with a long list of search terms | Excel Discussion (Misc queries) | |||
| IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
| Formula for If Term is on Certain Date then Count | Excel Worksheet Functions | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Hybrid Mode
