excel in the screening data

Circumstances:
A includes a set of data, 98263,17,0145,48,36,84156, ……
problem:
1.Is like A selected list of data in more than 70 the number of data And data of
2.Filter out the data does not <70 data

can try a variety of ways, both here Species:
1.A new, if written statement here, = if (A1> 70,1, if (A1 = 70,2,3)), enter the result will be displayed.Screening of a show to meet you 1 conditions, shows that the selection of 1, 2, you meet the conditions 2;

2.If you can sort the data, all in accordance with the data in ascending order, and then ……I do not have to say now? Data — Screening of custom drop-down menu to select the value you want to insert in the first line of his party into a new line in the A1, B1, type:value, type B2 to determine the conditions:> 70
election A Sino-out, click data – screening – screening of high-level, the first region to choose A series of regional conditions for the second option B1:B2, can press the Enter, the same reasoning could be elected <70 data

Leave a Reply