AdvancedFilterAction, Unique:=True

Andy D 2002 · May 21st, 2002, 09:56 AM

hi i use the following quite successfully, however can it be modified so doesnot copy blank cells?
thanks
Andy

range_1 = (Range("a1").End(xlDown).Row)
Range("w1:w" & range_1).AdvancedFilterAction:=xlFilterInPlace, Unique:=True

Mark W. · May 21st, 2002, 09:59 AM

Specify a criteria. See the Excel Help topic for "Examples of advanced filter criteria".

Andy D 2002 · May 22nd, 2002, 06:29 AM

thanks for reply but there does not seem to be anything there that enables you to filter unique records in a range excluding blanks

unless any other ideas, i will use a work around (copy non-blank cells to another sheet then use filter unique records)

Andy D 2002 · May 22nd, 2002, 06:29 AM

thanks for reply but there does not seem to be anything there that enables you to filter unique records in a range excluding blanks

unless any other ideas, i will use a work around (copy non-blank cells to another sheet then use filter unique records)

May 21st, 2002, 09:56 AM	#1
Andy D 2002 Board Regular Join Date: Apr 2002 Location: Andy Devine Posts: 106	hi i use the following quite successfully, however can it be modified so doesnot copy blank cells? thanks Andy range_1 = (Range("a1").End(xlDown).Row) Range("w1:w" & range_1).AdvancedFilterAction:=xlFilterInPlace, Unique:=True __________________ Andy Devine

May 22nd, 2002, 06:29 AM	#3
Andy D 2002 Board Regular Join Date: Apr 2002 Location: Andy Devine Posts: 106	thanks for reply but there does not seem to be anything there that enables you to filter unique records in a range excluding blanks unless any other ideas, i will use a work around (copy non-blank cells to another sheet then use filter unique records) __________________ Andy Devine

May 22nd, 2002, 06:29 AM	#4
Andy D 2002 Board Regular Join Date: Apr 2002 Location: Andy Devine Posts: 106	thanks for reply but there does not seem to be anything there that enables you to filter unique records in a range excluding blanks unless any other ideas, i will use a work around (copy non-blank cells to another sheet then use filter unique records) __________________ Andy Devine

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 21st, 2002, 09:59 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Specify a criteria. See the Excel Help topic for "Examples of advanced filter criteria".