Any way to filter cells containing formulas ?

[gaftalik]

Hi,
I need to filter cells with formulas and not to select them , is that possible by a simple or advanced filter ?
Thank you .

 

[Domenic]

First place this code into your workbook module...

1) Tools > Macro > Visual Basic Editor or press ALT+F11

2) Insert > Module

3) Copy and paste the following into the module...

Function IsFormula(rng As Range) As Boolean
IsFormula = rng.HasFormula
End Function

4) 'Close and Return to Microsoft Excel' or pess ALT+F11

Then, assuming that A1:B10 contains your data, and Column B contains your constants and formulas, try the following...

C1: leave empty

C2: =(1-isformula(B2))

Select/highlight A1:B10

Data > Filter > Advanced Filter

List Range: $A$1:$B$10

Criteria Range: $C$1:$C$2

Click Ok

Hope this helps!

 

[gaftalik]

it didnt work with me , it didnt filtered rows which contains formula .

 

[Domenic]

it didnt work with me , it didnt filtered rows which contains formula .

Would you like me to email you a sample?

 

[Domenic]

A sample has just been emailed to you...

 

[Domenic]

After running across the same post here, it seems that you actually want to display rows containing formulas, not constants. In this case, change the formula for C2 to...

=isformula(B2)

 

[gaftalik]

It worked very well thank you very much .