Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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...fo&userid=6450 View this thread: http://www.excelforum.com/showthread...hreadid=488232 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Any way to filter cells with formulas ?
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...fo&userid=6450 View this thread: http://www.excelforum.com/showthread...hreadid=488232 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Any way to filter cells with formulas ?
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...fo&userid=6450 View this thread: http://www.excelforum.com/showthread...hreadid=488232 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Any way to filter cells with formulas ?
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...fo&userid=6450 View this thread: http://www.excelforum.com/showthread...hreadid=488232 -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Any way to filter cells with formulas ?
Thank you much . It worked well . -- gaftalik ------------------------------------------------------------------------ gaftalik's Profile: http://www.excelforum.com/member.php...fo&userid=6450 View this thread: http://www.excelforum.com/showthread...hreadid=488232 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding cells that already have formulas | Excel Discussion (Misc queries) | |||
How to link cells in diff't workbooks that don't contain formulas | Excel Discussion (Misc queries) | |||
formula's in cells are not calculating | Excel Worksheet Functions | |||
adding cells that contain formulas that have returned error messag | Excel Worksheet Functions | |||
How do you show formulas in certain cells only (not the whole she. | Excel Worksheet Functions |