O office Apr 7, 2004 #1 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
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
F Frank Kabel Apr 7, 2004 #2 Hi not quite sure but - goto 'data - filter - autofilter' - in the appearing drop down listbox choose 'non blanks'
Hi not quite sure but - goto 'data - filter - autofilter' - in the appearing drop down listbox choose 'non blanks'
O office Apr 7, 2004 #3 no, auto-filter will not do it for me. I need to filter to a separate file and just leave out the blanks.
no, auto-filter will not do it for me. I need to filter to a separate file and just leave out the blanks.
F Frank Kabel Apr 7, 2004 #4 Hi then use 'Data - Filter - Special Filter' and choose a different location as target
D Dave Peterson Apr 7, 2004 #5 In American, it's Data|Filter|Advanced Filter Frank said: Hi then use 'Data - Filter - Special Filter' and choose a different location as target Click to expand...
In American, it's Data|Filter|Advanced Filter Frank said: Hi then use 'Data - Filter - Special Filter' and choose a different location as target Click to expand...
D Dave Peterson Apr 7, 2004 #6 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.
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.
