Filter

  • Thread starter Thread starter manjukhan
  • Start date Start date
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
 
You might take a look at the Advanced Filter/Copy to... feature rather than
the AutoFilter.

HTH |:>)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for Filter 2
Filtering with SUMIFS 1
How can I auto refresh a column that has an auto filter in place 1
Filtered drop down list 2
Filter for "blanks" in multiple columns simultaneously 2
filter non-blanks before closing 1
Auto Filter - how to collapse "non-blank" cells in a column? 2
AutoSum/Subtotal Inclusions/Exclusions 2

Back
Top