condensed way to filter this data using filter formula?

[daveyc18]

sheet 1:

column E header is "CL", but I want only from 60 and 69 (stored as text originally, but can convert to values if it makes it easier)

column N header is "Branch" and I want to EXCLUDE blanks (or in other words, anything with a branch #...this column is in values)

i want the filtered data in another sheet (eg sheet2)

 

[MARK858]

I want only from 60 and 69

What does this mean exactly? rows? you have multiple values in the column and you only want the values 60 and 69? you have values and you only want the ones between 60 and 69? something else?

 

[MARK858]

I am going to take a guess that it is

you have values and you only want the ones between 60 and 69?

Source sheet (Sheet1)

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	Order ID	Order Date	Site	SP Name	CL	Product Name	Ship To	Ship Via	Quantity	Order Total	Order Disc	Ship Charge	Cust Name	Branch	Cust Surname	Birthdate	Cust Address	Gender	Ph. Number	Email
2	106-12-F67	12/09/2013	Off Site	Robert King	57	Gudbrandsdalsost	Germany	Air	45	1566.4626	0	2819.63	Clarine	Germany	Hoogerwerf	30/01/1973	P.O. Box 74651, Ardoch, 57596	F	610-801-8610	clarine_hoogerwerf5557@mailsent.net
3	108-2-F11	02/01/2014	Off Site	Laura Callahan	55	Tunnbröd	South Africa	Sea	18	220.2708	0	198.24	Ehtel	South Africa	de Loos	11/11/1977	516 Velvet Fork, John Sam Lake, 39761	F	924-313-9299	deloos651@veryfast.biz
4	103-11-N03	11/09/2012	On Site	Robert King	55	Scottish Longbreads	South Africa	Air	15	276.8262	0	290.67	Harley	South Africa	Eijben	07/11/1959	222 Cedar Bluff Throughway, Milburn, 15451	M	360-123-0705	harley_eijben3787@swift-mail.com
5	105-30-F22	30/04/2013	Off Site	Margaret Peacock	51	Northwoods Cranberry Sauce	Germany	Sea	24	1146.0762	0	0	Rigoberto	Germany	Trevino	09/11/1981	362 Amber Center, Strauss Borough, 5303	M	963-260-7134	rigoberto4668@justemail.net
6	107-27-N56	27/11/2013	On Site	Laura Callahan	64	Gudbrandsdalsost	USA	Road	20	740.0994	0	1184.16	Earl		Barrett	20/05/1975	920 Noble Woods, Fowlerton, 36939	M	767-808-2322	earl_barrett5111@yepmail.net
7	110-9-F13	09/04/2014	Off Site	Andrew Fuller	67	Singaporean Hokkien Fried Mee	South Africa	Road	4	101.4486	0	16.23	Alise	South Africa	Velthuis	13/09/1937	P.O. Box 39844, Barrett, 27748	F	863-346-6272	velthuis1575@myfastmail.com
8	108-30-N05	30/12/2013	On Site	Andrew Fuller	70	Côte de Blaye	USA	Road	10	3274.4676	0	1309.79	Tyler	USA	Banks	02/12/1994	163 Round Throughway, Ormond-By-The-Sea, 78144	M	477-465-2337	banks166@myfastmail.com
9	107-16-N79	16/12/2013	On Site	Janet Leverling	62	Pavlova	Germany	Air	20	464.1282	0.16	185.65	Elodia	Germany	Schoonderbeek	07/05/1960	901 Amber Fillmore, Richview Village, 78701	F	475-696-8278	elodia_schoonderbeek605@fastest.cc
10	103-21-N59	21/11/2012	On Site	Steven Buchanan	60	Pavlova	UK	Air	56	1171.8174	0	3281.09	Vanna		de Ridder	26/06/1972	917 Maple Terrace, Mayview, 89223	F	639-216-5168	vanna1084@fastmail.to
11	107-27-N18	27/10/2013	On Site	Nancy Davolio	64	Queso Manchego La Pastora	Germany	Sea	36	1754.3232	0.16	3157.78	Ryan		Hallen	08/01/1946	989 Log Bay, Seymour, 13374	M	964-588-4938	ryan_hallen1880@fastemailer.com
12	103-13-F82	13/12/2012	Off Site	Margaret Peacock	62	Geitost	Germany	Sea	60	244.8378	0	146.9	Keneth		Bentley	29/05/1953	941 Gate Hollow, Hammondville, 14654	M	786-347-3917	bentley217@fastimap.com
13	108-4-N68	04/02/2014	On Site	Robert King	66	Gumbär Gummibärchen	Brazil	Road	20	930.0918	0.27	1302.13	Nikita		Mcdaniel	04/08/1946	P.O. Box 87538, Frannie, 45562	F	230-000-7885	nikita3919@emailcorner.net
14	107-24-N16	24/10/2013	On Site	Margaret Peacock	67	Sir Rodney's Scones	Brazil	Air	5	82.7298	0	24.82	Katie	Brazil	Lindsay	13/11/1971	44 Red Fort, Falling Spring, 87788	F	400-327-2433	lindsay4838@imapmail.org
15	103-10-N78	10/12/2012	On Site	Steven Buchanan	50	Fløtemysost	Sweden	Rail	6	123.8496	0	59.45	Dusty	Sweden	Cowan	02/11/1995	P.O. Box 14044, Schofield Barracks, 36084	F	830-504-4189	dusty5580@mailbolt.com
16	105-21-N12	21/04/2013	On Site	Robert King	50	Camembert Pierrot	Brazil	Road	12	399.3762	0	239.63	An	Brazil	Haley	01/04/1985	559 Jagged Apple, Lead, 8581	F	442-156-4454	an4982@fastimap.com
17	108-30-N04	30/12/2013	On Site	Michael Suyama	69	Rössle Sauerkraut	UK	Road	24	1278.7722	0	2148.34	Nathalie	UK	Henson	05/02/1946	344 Harvest Grove Orchard, Saxapahaw, 21914	F	390-390-7727	henson2960@fastmail.net
18	108-16-N89	16/02/2014	On Site	Anne Dodsworth	66	Côte de Blaye	USA	Air	40	12335.4954	0.07	24670.99	Rashad	USA	Bryant	12/10/1972	P.O. Box 32474, Fair Bluff, 999	M	957-750-5231	rashad666@cluemail.com
19	106-25-N11	25/07/2013	On Site	Michael Suyama	59	Chang	Sweden	Sea	10	308.541	0.06	0	Joey	Sweden	Hooper	27/11/1976	P.O. Box 80643, Kiel, 29691	M	277-265-5425	joey1801@fmailbox.com
20	102-15-N56	15/07/2012	On Site	Janet Leverling	70	Original Frankfurter grüne Soße	Brazil	Sea	12	158.1978	0	75.93	Hyman	Brazil	Chayah	22/03/1952	594 Green Isle, Briny Breezes, 31628	M	386-636-1615	hyman_chayah2380@fastmail.co.uk
21	108-16-F90	16/02/2014	Off Site	Robert King	61	Alice Mutton	France	Road	15	704.2464	0	422.55	Juan	France	Allen	12/06/1942	838 Forge Chase, Lake Shangrila, 12482	M	536-087-6049	juan2085@promessage.com
Sheet1

Destination sheet (Sheet2)

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	Order ID	Order Date	Site	SP Name	CL	Product Name	Ship To	Ship Via	Quantity	Order Total	Order Disc	Ship Charge	Cust Name	Branch	Cust Surname	Birthdate	Cust Address	Gender	Ph. Number	Email
2	110-9-F13	09/04/2014	Off Site	Andrew Fuller	67	Singaporean Hokkien Fried Mee	South Africa	Road	4	101.4486	0	16.23	Alise	South Africa	Velthuis	13771	P.O. Box 39844, Barrett, 27748	F	863-346-6272	velthuis1575@myfastmail.com
3	107-16-N79	16/12/2013	On Site	Janet Leverling	62	Pavlova	Germany	Air	20	464.1282	0.16	185.65	Elodia	Germany	Schoonderbeek	22043	901 Amber Fillmore, Richview Village, 78701	F	475-696-8278	elodia_schoonderbeek605@fastest.cc
4	107-24-N16	24/10/2013	On Site	Margaret Peacock	67	Sir Rodney's Scones	Brazil	Air	5	82.7298	0	24.82	Katie	Brazil	Lindsay	26250	44 Red Fort, Falling Spring, 87788	F	400-327-2433	lindsay4838@imapmail.org
5	108-30-N04	30/12/2013	On Site	Michael Suyama	69	Rössle Sauerkraut	UK	Road	24	1278.7722	0	2148.34	Nathalie	UK	Henson	16838	344 Harvest Grove Orchard, Saxapahaw, 21914	F	390-390-7727	henson2960@fastmail.net
6	108-16-N89	16/02/2014	On Site	Anne Dodsworth	66	Côte de Blaye	USA	Air	40	12335.4954	0.07	24670.99	Rashad	USA	Bryant	26584	P.O. Box 32474, Fair Bluff, 999	M	957-750-5231	rashad666@cluemail.com
7	108-16-F90	16/02/2014	Off Site	Robert King	61	Alice Mutton	France	Road	15	704.2464	0	422.55	Juan	France	Allen	15504	838 Forge Chase, Lake Shangrila, 12482	M	536-087-6049	juan2085@promessage.com
Sheet2

Cell Formulas
Range	Formula
A1:T1	B1	=Sheet1!B1
A2:T7	A2	=FILTER(Sheet1!A2:T21,(Sheet1!E2:E21>=60)*(Sheet1!E2:E21<=69)*(Sheet1!N2:N21<>""))
Dynamic array formulas.

 

[daveyc18]

What does this mean exactly? rows? you have multiple values in the column and you only want the values 60 and 69? you have values and you only want the ones between 60 and 69? something else?

only 60 and 69

 

[MARK858]

=FILTER(Sheet1!$A$2:$T$21,ISNUMBER(MATCH(Sheet1!$E$2:$E$21,{60,69},0))*(Sheet1!$N$2:$N$21<>""),"")