Home |
Search |
Today's Posts |
#1
|
|||
|
|||
differentiating between formulas and values
I have a bunch of values in column A. In column B, I'm using a user-defined function that processes the values in column A and returns either text of some sort or a blank. However, even though the cells in column B appear to be unique -- well, except for the blank cells -- the formula in each cell is essentially identical (e.g. B1 is =UDF(A1), B2 is =UDF(A2) etc.). I want to do an operation only on those cells in column B that are displaying text, but I don't know how to do that automatically. Is there a way to somehow differentiate between cells that return a "tangible" value, and those that return a "blank" value? -- shellshock ------------------------------------------------------------------------ shellshock's Profile: http://www.excelforum.com/member.php...o&userid=24935 View this thread: http://www.excelforum.com/showthread...hreadid=385124 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
#N/A Values : Returned by Formulas vs Entered Manually | Charts and Charting in Excel | |||
How do I sum rounded values from two seperate formulas in Excel? | Excel Worksheet Functions | |||
How do I clear a worksheet of values, but leave formulas intact? | Excel Worksheet Functions | |||
display values of formulas in Excel | Excel Worksheet Functions | |||
delete values in several cells without deleting the formulas | Excel Discussion (Misc queries) |