Advanced Filter Is Not Working

[PMcGinness]

Hello,

I have a range of student data. Some rows are duplicated student information. My goal is to use Advanced Filter to show unique records only. However, I continue to face an error when I start to use Advanced Filter.



If it helps, I have a snip of the Advanced Filter dialog box:


I've tried closing Excel, using a different sheet in my workbook, and starting with a new workbook all to no avail.

What might be wrong? I'm now really curious as why I have this roadblock.

 

[MARK858]

I think the message is quite clear you need at least 2 rows of source data, A2:W2 is only one row.
You also need some criteria or you need to mark the Unique checkbox.

 

[PMcGinness]

I think the message is quite clear you need at least 2 rows of source data, A2:W2 is only one row.
You also need some criteria or you need to mark the Unique checkbox.

I didn't check the unique records box for the snip, but I do check that when I test things.

I also change the rows to include all my data (i.e $A$2:$W$50), and now all that happens is my filter is turned off.

 

[MARK858]

With the data set below

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1	Order ID	Order Date	Site	SP Name	Category Name	Product Name	Ship To	Ship Via	Quantity	Order Total	Order Disc	Ship Charge	Cust Name	Cust Initials	Cust Surname	Birthdate	Cust Address	Gender	Ph. Number	Email	Company	Job Title	URL
2	104-12-F72	12/03/2013	Off Site	Laura Callahan	Beverages	Guaraná Fantástica	UK	Road	80	316.692	0	506.71	Lekisha		van Eyk	10/04/1948	P.O. Box 62244, Genesee, 66112	F	816-420-2613	lekisha9853@gmail.com	Ppzhan	Front Desk Agent	http://www.ppzhan.com
3	110-9-F13	09/04/2014	Off Site	Andrew Fuller	Grains/Cereals	Singaporean Hokkien Fried Mee	South Africa	Road	4	101.4486	0	16.23	Alise		Velthuis	13/09/1937	P.O. Box 39844, Barrett, 27748	F	863-346-6272	velthuis1575@myfastmail.com	Sakshi	Application Engineer	http://www.sakshi.com
4	104-25-N56	25/02/2013	On Site	Laura Callahan	Confections	Sir Rodney's Scones	Germany	Road	40	319.3368	0	638.67	Lissa		Haak	13/04/1936	993 Wishing Summit, Flandreau, 79939	F	533-501-4716	haak4102@fmgirl.com	Buscape	Medical Sales	http://www.buscape.com
5	105-1-N23	01/05/2013	On Site	Robert King	Meat/Poultry	Alice Mutton	UK	Sea	25	1088.8482	0.24	1361.06	Fermin		Nieves	02/04/1975	15 Berry Trafficway, Bonner Springs, 7051	M	378-870-8356	fermin_nieves5841@internet-e-mail.com	Crautos	Mortgage Loan Underwriter	http://www.crautos.com
6	104-12-F72	12/03/2013	Off Site	Laura Callahan	Beverages	Guaraná Fantástica	UK	Road	80	316.692	0	506.71	Lekisha		van Eyk	10/04/1948	P.O. Box 62244, Genesee, 66112	F	816-420-2613	lekisha9853@gmail.com	Ppzhan	Front Desk Agent	http://www.ppzhan.com
7	105-30-N83	30/06/2013	On Site	Andrew Fuller	Meat/Poultry	Thüringer Rostbratwurst	Australia	Road	10	1419.5052	0.29	1135.6	Tony	R.N.	Miedema	07/08/1975	271 Green Forge Bank, The Woodlands, 54593	M	724-070-7574	miedema6305@ml1.net	Pcworld	Business System Analyst	http://www.pcworld.com
8	108-29-F58	29/01/2014	Off Site	Andrew Fuller	Beverages	Outback Lager	France	Air	4	128.2614	0	25.65	Rhett		Carr	13/04/1979	34 Stony Brook, Burlingame, 42942	M	600-788-1353	rhett_carr2488@fastmessaging.com	Mulberry	Hospice Administrator	http://www.mulberry.com
9	104-12-F72	12/03/2013	Off Site	Laura Callahan	Beverages	Guaraná Fantástica	UK	Road	80	316.692	0	506.71	Lekisha		van Eyk	10/04/1948	P.O. Box 62244, Genesee, 66112	F	816-420-2613	lekisha9853@gmail.com	Ppzhan	Front Desk Agent	http://www.ppzhan.com
10	104-12-F43	12/02/2013	Off Site	Laura Callahan	Produce	Rössle Sauerkraut	Italy	Sea	12	513.855	0	369.98	Logan	A.W.G.	van Westhrenen	24/05/1993	P.O. Box 61503, Okahumpka, 18108	M	215-700-2735	logan_vanwesthrenen9476@fastmail.co.uk	Patrika	Child Care Worker	http://www.patrika.com
11	108-5-N71	05/02/2014	On Site	Anne Dodsworth	Condiments	Grandma's Boysenberry Spread	France	Road	50	1481.7378	0	3704.34	Antonina	U.P.U.	Cantu	11/04/1958	594 Middle View, Manteno Village, 78240	F	858-646-4432	antonina7536@h-mail.us	Clickpb	Psychological Aide	http://www.clickpb.com
Sheet2

The Advanced Filter

works fine for me with the result

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1	Order ID	Order Date	Site	SP Name	Category Name	Product Name	Ship To	Ship Via	Quantity	Order Total	Order Disc	Ship Charge	Cust Name	Cust Initials	Cust Surname	Birthdate	Cust Address	Gender	Ph. Number	Email	Company	Job Title	URL
2	104-12-F72	12/03/2013	Off Site	Laura Callahan	Beverages	Guaraná Fantástica	UK	Road	80	316.692	0	506.71	Lekisha		van Eyk	10/04/1948	P.O. Box 62244, Genesee, 66112	F	816-420-2613	lekisha9853@gmail.com	Ppzhan	Front Desk Agent	http://www.ppzhan.com
3	110-9-F13	09/04/2014	Off Site	Andrew Fuller	Grains/Cereals	Singaporean Hokkien Fried Mee	South Africa	Road	4	101.4486	0	16.23	Alise		Velthuis	13/09/1937	P.O. Box 39844, Barrett, 27748	F	863-346-6272	velthuis1575@myfastmail.com	Sakshi	Application Engineer	http://www.sakshi.com
4	104-25-N56	25/02/2013	On Site	Laura Callahan	Confections	Sir Rodney's Scones	Germany	Road	40	319.3368	0	638.67	Lissa		Haak	13/04/1936	993 Wishing Summit, Flandreau, 79939	F	533-501-4716	haak4102@fmgirl.com	Buscape	Medical Sales	http://www.buscape.com
5	105-1-N23	01/05/2013	On Site	Robert King	Meat/Poultry	Alice Mutton	UK	Sea	25	1088.8482	0.24	1361.06	Fermin		Nieves	02/04/1975	15 Berry Trafficway, Bonner Springs, 7051	M	378-870-8356	fermin_nieves5841@internet-e-mail.com	Crautos	Mortgage Loan Underwriter	http://www.crautos.com
7	105-30-N83	30/06/2013	On Site	Andrew Fuller	Meat/Poultry	Thüringer Rostbratwurst	Australia	Road	10	1419.5052	0.29	1135.6	Tony	R.N.	Miedema	07/08/1975	271 Green Forge Bank, The Woodlands, 54593	M	724-070-7574	miedema6305@ml1.net	Pcworld	Business System Analyst	http://www.pcworld.com
8	108-29-F58	29/01/2014	Off Site	Andrew Fuller	Beverages	Outback Lager	France	Air	4	128.2614	0	25.65	Rhett		Carr	13/04/1979	34 Stony Brook, Burlingame, 42942	M	600-788-1353	rhett_carr2488@fastmessaging.com	Mulberry	Hospice Administrator	http://www.mulberry.com
10	104-12-F43	12/02/2013	Off Site	Laura Callahan	Produce	Rössle Sauerkraut	Italy	Sea	12	513.855	0	369.98	Logan	A.W.G.	van Westhrenen	24/05/1993	P.O. Box 61503, Okahumpka, 18108	M	215-700-2735	logan_vanwesthrenen9476@fastmail.co.uk	Patrika	Child Care Worker	http://www.patrika.com
11	108-5-N71	05/02/2014	On Site	Anne Dodsworth	Condiments	Grandma's Boysenberry Spread	France	Road	50	1481.7378	0	3704.34	Antonina	U.P.U.	Cantu	11/04/1958	594 Middle View, Manteno Village, 78240	F	858-646-4432	antonina7536@h-mail.us	Clickpb	Psychological Aide	http://www.clickpb.com
Sheet2

 

[MARK858]

Is some of your data with a defined table and some of it outside the table?

 

[PMcGinness]

Is some of your data with a defined table and some of it outside the table?

All my data is a range at this point.

 

[MARK858]

I also change the rows to include all my data (i.e $A$2:$W$50), and now all that happens is my filter is turned off.

Can you explain what you mean by "my filter is turned off".
Do you mean it is greyed out?
Do you mean that you are trying to apply an Advanced filter to rows that are already filtered normally (I don't think that you can have both if you are)?

 

[PMcGinness]

Can you explain what you mean by "my filter is turned off".
Do you mean it is greyed out?
Do you mean that you are trying to apply an Advanced filter to rows that are already filtered normally (I don't think that you can have both if you are)?

Hello,

I solved my issue. I am a dunce. I really appreciate your help thus far.

 

[MARK858]

Happy that you got it sorted