filtering out blanks

  • Thread starter Thread starter office
  • Start date Start date
O

office

I am trying to filter a list from 1 column to another minus the blanks. Is
there an easy way of doing this?

Thanks in advance
 
Hi
not quite sure but
- goto 'data - filter - autofilter'
- in the appearing drop down listbox choose 'non blanks'
 
no, auto-filter will not do it for me. I need to filter to a separate file
and just leave out the blanks.
 
Hi
then use 'Data - Filter - Special Filter' and choose a different
location as target
 
You could use Data|filter|autofilter, show non-blanks.

Then copy those visible cells to a new worksheet.

Another option.
Sort by the column and group all your blanks together. Then delete that group.

Another option.
Copy the whole worksheet to a new worksheet.
Data|filter|autofilter
show blanks
Delete those visible rows.
 
Back
Top