To filter a list by drop down condition by using data validation list

[srehman]

Drop Down List Based on Conditions ( By data validation list of conditions)
	Condition 1	means between 1 to 100	>=1,<=100
	Condition 2	means between -1 to -100	<=-1,>=100
aim to filter below list by above drop down condition
10
-20
30
40
-76
-18
-9
200
99
-150

 

[Yongle]

You can filter using Data Filter \ Number filter \ Custom Filter

 

[srehman]

Please read the conditions again you are on basic level approach.

 

[Yongle]

What ???

 

[Yongle]

If you want to use data validation in one column based on a condition in another column

Data validation in B2 copied down
with source formula: ::: =IF(A2="A",POSITIVE,IF(A2="B",NEGATIVE,"XXX"))

POSITIVE and NEGATIVE are 2 named ranges containing a LIST of valid values (1 to 100 and -1 to -100)

 

[srehman]

You got it , i will try your approach & will come back with results.
Thanks for your time and support much appreciated

Thanks
Take care