Set Criteria

[howard]

I have criteria in S2 set as >= 150


I would to amend this so that it extracts data > 150 but less than 200

Excel 2012
	S
1	Days in stock
2	>=365
Sheet1

It would be appreciated if someone could kindly assist me

 

[BrianJN1]

Do you mean something like this:
=IF(AND(X1>=150,X1<200),X1,"") ?

"X" is the column where the data resides.

 

[Marcelo Branco]

I suppose you are using this criteria (S1:S2) in Advanced Filter. If so, try

	S​	T​
1​	Days in stock​	Days in stock​
2​	>150​	<200​

<tbody>
</tbody>

and set
Criteria Range: $S$1:$T$2

Hope this helps

M.

 

[howard]

Thanks for the input. Marcelo's solution is more suitable as the criteria resides in Col S & T