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


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