Advanced filter Criteria

[howard]

I have the following data below


I want to extract the data on sheet1 containing <14%, >=15% and excluding % using advanced Filter but cannot get it to work

Book1
	A	B
1	VALUE	Vat %
2	16.81	0.00%
3	25.25	0.00%
4	35.37	14.00%
5	27.39	13.00%
6	27.39	15.00%
7	91.01	12.00%
8	309.25	0.00%
9	169.25	14.00%
10
11
Sheet1

See Sheet Advanced filter sheet below

Book1
	A	B	C	D	E	F	G	H
1	VALUE	Vat %						Vat %
2	16.81	0.00%						<>0%
3	25.25	0.00%						<14%
4	35.37	14.00%						>=15%
5	27.39	13.00%
6	27.39	15.00%
7	91.01	12.00%
8	309.25	0.00%
9	169.25	14.00%
10
11
12
13
14
15
16
17
18
19
ADVANCED fILTER

it would be appreciated if someone could kindly assist me

 

[Jerry Sullivan]

Hi Howard,

You can use a formula-based criteria like this....

Clear cell H1 (it must be empty)
In H2: =AND(B2<>0,OR(B2<14%,B2>=15%))

In the Advanced Filter dialog, select H1:H2 as the Criteria Range.

 

[howard]

Hi Jerry

Thanks for the help. The formula for the criteria range works perfectly