: $$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
= True
End If
Next
Application.ScreenUpdating = True
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sara L
Sent: Friday, August 19, 2011 6:24 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ filter out the cells
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 cells have vlook up(
with true parameter) and some with (false parameter) How do i filter
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