Advance Filter - extract data with formula (not only the Values)

[toirshad]

Dear all,

Whenever I use Advance Filter, its giving me 'Values' only, its not extracting 'Formula' contains in the cell.

Kindly help me on this regard.

regards,
Irshad K

 

[Robert Mika]

Hi and welcome to the forum.
And it wont that the way it works.
If you woudl like to copy your formulas use Paste Special option when you copy and then paste your data.