: $$Excel-Macros$$ filter out the cells with a particular formula
see if it helps
On Fri, Aug 19, 2011 at 6:24 AM, Sara Lee lee.sar...@gmail.com wrote:
hi
how do i filter out those cells in a column which has a particular vlookup
formula in them... for example in one column in a table, i have
Try this
Sub Filter()
Application.ScreenUpdating = False
On Error Resume Next
Dim Rec As Double
Dim rng As Range
Set rng = Selection
Rec = Range(A6).End(xlUp).Row
For i = 1 To Rec
If InStr(rng.Cells(i, 1).Formula, Range(C1).Value) Then
rng.Cells(i, 0).EntireRow.Hidden
see if it helps
On Fri, Aug 19, 2011 at 6:24 AM, Sara Lee lee.sar...@gmail.com wrote:
hi
how do i filter out those cells in a column which has a particular vlookup
formula in them... for example in one column in a table, i have vlook up
fomula set up for the entire column ... some of the
Thanks Ashish... but how do i filter out column I such that i extract values
similar to a ( which use 0) and not b. Say suppose column I has 2cell
records ... ?
On Thu, Aug 18, 2011 at 9:05 PM, ashish koul koul.ash...@gmail.com wrote:
see if it helps
On Fri, Aug 19, 2011 at 6:24 AM, Sara
lets suppose col i is having formula
type in j2 = checkpar(I2)
then apply fill down
use flliter and choose You have choosed 0 in j it will show all the
cells with paramter 0 in col i.
On Fri, Aug 19, 2011 at 7:06 AM, Sara Lee lee.sar...@gmail.com wrote:
Thanks Ashish... but how do i