| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Filter
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 |
|
#2
|
|||
|
|||
|
You might take a look at the Advanced Filter/Copy to... feature rather than
the AutoFilter. HTH |:) "manjukhan" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro for Filter Switches ... Maybe??? | Excel Discussion (Misc queries) | |||
| Filter Switches vs Macro? | Excel Discussion (Misc queries) | |||
| Pivot table and filter | New Users to Excel | |||
| advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
| Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions | |||
Linear Mode
