Home |
Search |
Today's Posts |
#1
|
|||
|
|||
filter for non-formulas
I have a list of data. Is there a way I can filter a column of rows to
extract only those cells that do not contain formulas? |
#2
|
|||
|
|||
Hi
you could use a helper column together with a UDF. Put the following code in one of your modules: public function is_formula(rng as range) is_formula=rng.hasformula end function and use this in your helper column: =IS_FORMULA(A1) -- Regards Frank Kabel Frankfurt, Germany "S. H. Drew" schrieb im Newsbeitrag ... I have a list of data. Is there a way I can filter a column of rows to extract only those cells that do not contain formulas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Filter Problem | Excel Discussion (Misc queries) | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
Filter changes upon reopening file! | Excel Discussion (Misc queries) | |||
filter and count | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |