| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Picking values out
Hi,
I am looking to be able to have a cell that will pick a value/s from a cell next to it. example.... In the cells here I could have any instructions of things to do RowA starting with Cell A2 School Run 8.45am *5234443* DHT *5234444* Beware of Dog *5234445* *5234446* Fit Part I want to pick out all the values starting with *5 from the column A. How is this possible as the user can type all different information in this field. I have tried the Left, Mid, & Right functions but this would not pick all up as the may not be in these postions. Any Ideas, as I am stuck. Regards, Jez |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keeping a cell value constant trhoughout a list of values | Excel Worksheet Functions | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions | |||
| #N/A Values : Returned by Formulas vs Entered Manually | Charts and Charting in Excel | |||
Threaded Mode
