Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter by formula | Excel Worksheet Functions | |||
Filter formula | Excel Worksheet Functions | |||
FILTER FORMULA | Excel Discussion (Misc queries) | |||
filter with formula | Excel Discussion (Misc queries) | |||
Filter formula | Excel Worksheet Functions |