Data - Filter - Autofilter choose NonBlanks Per Erik
F Frank Kabel Feb 16, 2004 #2 Hi one way (without using VBA). If you have a heading row try the following - select your heading row - goto 'Data - Filter - Autofilter' - In the columns of your choice click on the filter listbox and choose 'non blanks'.
Hi one way (without using VBA). If you have a heading row try the following - select your heading row - goto 'Data - Filter - Autofilter' - In the columns of your choice click on the filter listbox and choose 'non blanks'.
