Is it possible to filter on formula used, in Excel? -

does know if possible set filter on formula used rather on value returned in excel. i'm using excel 2010.

in column next data add formula below , change f2 cell reference cell contains formula want filter on.

=formulatext(f2) 

copy formula down , filter on new column.

for earlier versions of excel don't have formulatext can use following udf:

function formulatext(x range)   formulatext = x.formula end function