Can command Advanved Filter do without selecting header(i.e. just process cells)?

Aquinax · #1 08-07-2013, 04:13 AM

I'm using the command Advanved Filter to filter out duplicate data entries quite frequently and it pains me to every stipulate the header for a row of data as the program asks to do. Yet sometimes it(Excel) goes about this filtering business without pestering me about its need for a header. And does it without fault (the first row is included in the data to be filtered and is not treated as a header). So I'm asking those more experienced - is it possible to 'tell' the program to never ask me for a header when Advanced Filtering and always treat the first row as a header?

excelledsoftware · #2 08-08-2013, 06:58 PM

Quote:

Originally Posted by Aquinax

I'm using the command Advanved Filter to filter out duplicate data entries quite frequently and it pains me to every stipulate the header for a row of data as the program asks to do. Yet sometimes it(Excel) goes about this filtering business without pestering me about its need for a header. And does it without fault (the first row is included in the data to be filtered and is not treated as a header). So I'm asking those more experienced - is it possible to 'tell' the program to never ask me for a header when Advanced Filtering and always treat the first row as a header?

What about recording a macro and then running it each time.

Aquinax · #3 08-10-2013, 03:39 AM

Quote:

Originally Posted by excelledsoftware

What about recording a macro and then running it each time.

Yeah, but I wouldn't even know what makes Excel behave one time this way (first row of data treated as part of data) and at another time differently (i.e. the first row is regarded as header).

excelledsoftware · #4 08-10-2013, 05:16 PM

Quote:

Originally Posted by Aquinax

Yeah, but I wouldn't even know what makes Excel behave one time this way (first row of data treated as part of data) and at another time differently (i.e. the first row is regarded as header).

Testing this code it automatically assigns the first row as header and does not prompt you. Assign this macro to a button. Then select the header and run the macro. It should display just the unique records. Let me know what you think or if you want code that will automatically copy and paste it to a new location.

Code:

Sub UniqueFilter()
 
' Code to automatically select entire list of data
' and advance filter the unique records in place.

    Range(Selection, Selection.End(xlDown)).Select
    Selection.AdvancedFilter Action:=xlFilterInPlace, Unique:=True
 
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
In Excel 2007-After Selecting Visibe Cells-How do I "Copy to Visible cells" Only	mag	Excel	0	10-28-2012 08:04 PM
automating a repetitive process	vthomeschoolmom	Excel Programming	1	02-28-2012 07:41 PM
Selecting blank cells in criteria	apolloman	Excel	6	08-24-2011 05:38 AM
filling multiple cells whislt using Filter	VinceO	Excel	1	05-09-2011 06:38 AM
Configuration process problem	Dunn2009	Outlook	0	10-02-2009 02:38 AM