Any way to filter cells with formulas ?

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


-- 
gaftalik
------------------------------------------------------------------------
gaftalik's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=6450
View this thread: http://www.excelforum.com/showthread.php?threadid=488232

0
11/25/2005 6:06:52 PM
excel.misc 78881 articles. 5 followers. Follow

4 Replies
422 Views

Similar Articles

[PageSpeed] 19

Maybe....

But I think you'll have to expand on what you really want...

gaftalik wrote:
> 
> Hi,
> I need to filter cells with formulas and not to select them , is that
> possible by a simple or advanced filter ?
> Thank you .
> 
> --
> gaftalik
> ------------------------------------------------------------------------
> gaftalik's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=6450
> View this thread: http://www.excelforum.com/showthread.php?threadid=488232

-- 

Dave Peterson
0
petersod (12005)
11/25/2005 9:06:54 PM
In a range of cells which contains constant values and formulas , i nee
to add a filter or a macro to filter all cells that contain onl
formulas in a way to hide the rows in which there is a constant valu
cell ! is that possible ?

Thank you much 

--
gaftali
-----------------------------------------------------------------------
gaftalik's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=645
View this thread: http://www.excelforum.com/showthread.php?threadid=48823

0
11/26/2005 3:50:56 PM
You could use a UserDefined Function that returns true/false depending on if
there's a formula in that cell:

Option Explicit
Function HasFormula(rng as range) as boolean
  set rng = rng.cells(1) 'only one cell
  HasFormula=rng.hasformula
end function

Then you could add a column of helper cells that contain formulas:

=hasformula(a1)
(and drag down)
and filter on that.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

gaftalik wrote:
> 
> In a range of cells which contains constant values and formulas , i need
> to add a filter or a macro to filter all cells that contain only
> formulas in a way to hide the rows in which there is a constant value
> cell ! is that possible ?
> 
> Thank you much .
> 
> --
> gaftalik
> ------------------------------------------------------------------------
> gaftalik's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=6450
> View this thread: http://www.excelforum.com/showthread.php?threadid=488232

-- 

Dave Peterson
0
petersod (12005)
11/26/2005 5:22:14 PM
Thank you much . It worked well .


-- 
gaftalik
------------------------------------------------------------------------
gaftalik's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=6450
View this thread: http://www.excelforum.com/showthread.php?threadid=488232

0
11/26/2005 5:51:06 PM
Reply:

Similar Artilces: