Advanced Criteria extracting % <14% and those less than 14%

[howard]

I have data on sheet 3. I have Sales GP percentages in Col G on sheet 3


I have set up criteria on Sheet 4 to extract the data in Col's A:G where the % > 14% and those less than 14%. However when using advanced Filter all the percentages are being extracted


I only want to extract the data on sheet 4 where the % is greater than 14% and those that are less than 14%

See my criteria below


It would be appreciated if someone could kindly assist me and setting up correctly

Excel 2012
	R
1	Sales GP %
2	>14%
3	<14%
Sales GP Not 14%

 

[howard]

Have amended criteria as follows:

Excel 2012
	R
1	Sales GP %
2	>14% & <14%
Sales GP Not 14%

It appears to be working fine. Is this the correct way to set up my criteria ?

 

[howard]

I have set up an addtional crteria to extract tax category "Home" as folows but all the tax categories are extracted when using advanced criteria


It would be appreciated if someone could kindly assist

Excel 2012
	Q	R
1	Tax Category	Sales GP %
2	Home	>14% & <14%
Sales GP Not 14%

See sample data containing the various tax categories

Excel 2012
	D
1	Tax Category
2	Home
3	Home
4	Home
5	Internal
6	Home
7	Internal
8	Home
9	Home
Sales GP Not 14%

 

[Aladin Akyurek]

Care to post the data you must submit to Advanced Filter?

 

[howard]

Thanks Aladin. I managed to sort it out