Filter

M

manjukhan

Could anyone of you guys tell me how to do the following.

I need to filter a column for non blanks and list the values on a
different column. I can do this by doing a autofilter and filter for
non blanks . But I want to do it automatically with a formula. Do any
one have a formula accomplish this.

Thanks
Mansoor A Khan
 
C

CyberTaz

You might take a look at the Advanced Filter/Copy to... feature rather than
the AutoFilter.

HTH |:>)
 
Top