Selecting data based on some conditons

[aniketiitr]

Hi, i have this data
A B
0.4 0.2
0.5 0.7
0.84 0.61
0.92 0.23

and so on

Now i want to select and separate data based on following two conditions (to be done one by one)
1. A>0.80 when B>0.60
2. A<0.90 when B<0.20
How to do these two

 

[BlueHornet]

I'm not sure what you mean by "select and separate". Is it your intention to apply a filter of some kind? Because that's not difficult. If you're looking at a formula to identify the conditions, how about this (note that I modified one of your data points to make it meet the second condtion):

Excel Workbook
	A	B	C	D
1	A	B
2	0.4	0.19		Second Condition
3	0.5	0.7
4	0.84	0.61		First Condition
5	0.92	0.23
Sheet2

Excel 2010

Cell Formulas
Range	Formula
D2	=IF( AND( A2 > 0.8, B2 > 0.6), "First Condition", IF( AND( A2< 0.9, B2< 0.2), "Second Condition", ""))
D3	=IF( AND( A3 > 0.8, B3 > 0.6), "First Condition", IF( AND( A3< 0.9, B3< 0.2), "Second Condition", ""))
D4	=IF( AND( A4 > 0.8, B4 > 0.6), "First Condition", IF( AND( A4< 0.9, B4< 0.2), "Second Condition", ""))
D5	=IF( AND( A5 > 0.8, B5 > 0.6), "First Condition", IF( AND( A5< 0.9, B5< 0.2), "Second Condition", ""))