| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
evaluating text of cells
I'm trying to select certain cells base on availability.
eg. on sheet 1 cell A1 has the text value "AgeLine (F)" the (F) indicates it is available. on sheet 2 I want a list of available items. there are around 1000 cells on sheet 1 or which 150 are available. any ideas on how to achieve the this list? thanks Glenn |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
evaluating text of cells
You could test for RIGHT(A1,3) being equal to "(F)".
-- David Biddulph wrote in message ... I'm trying to select certain cells base on availability. eg. on sheet 1 cell A1 has the text value "AgeLine (F)" the (F) indicates it is available. on sheet 2 I want a list of available items. there are around 1000 cells on sheet 1 or which 150 are available. any ideas on how to achieve the this list? thanks Glenn |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dsum evaluating only the beginning of a string? | Excel Worksheet Functions | |||
| Evaluating a range | Excel Discussion (Misc queries) | |||
| evaluating text cell contents | Excel Discussion (Misc queries) | |||
| If formula evaluating 2 cells contents | Excel Worksheet Functions | |||
| Evaluating similarity of text strings | Excel Worksheet Functions | |||
Linear Mode
