| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Computed value returning#VALUE
I have a computed value
=TRIM(MID(SUBSTITUTE(U3,",",REPT(" ",255),2),FIND(",",U3)+1,255)) that pulls the date out of a string of text. In this case, the date is returned because their is data in U3. However, when I have columns that do not have data, it returns a #VALUE. Is there a way to get around this. The column being referenced is also a computed value, so I am wondering if that is the case. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| computed named cell references | New Users to Excel | |||
| cell values being computed | Excel Worksheet Functions | |||
| Change the way a non-computed percentage is displayed | Excel Discussion (Misc queries) | |||
| VLOOKUP - computed go to | Excel Worksheet Functions | |||
| Advanced Filtering - Computed Criteria | Excel Worksheet Functions | |||
Threaded Mode
