Formula for Filter
 

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


--
manjukhan
------------------------------------------------------------------------
manjukhan's Profile: http://www.excelforum.com/member.php...o&userid=25268
View this thread: http://www.excelforum.com/showthread...hreadid=387567

Formula for Filter
 

Build code to do Advanced Filter with the criteria range 0

Do this manually with the recorder on, than edit the recorded code.

--
steveB

Remove "AYN" from email to respond
"manjukhan" wrote in
message ...

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


--
manjukhan
------------------------------------------------------------------------
manjukhan's Profile:
http://www.excelforum.com/member.php...o&userid=25268
View this thread: http://www.excelforum.com/showthread...hreadid=387567