Largest is like the Top 10 we saw in AutoFilter, but you can specify a number other than 10, such the 5 largest values in the field. Equals, less than, greater than, less than or equal, and greater than or equal are all pretty standard conditions. But the Standard Filter gives you a ton of options: Using AutoFilter, every filter is implicitly set to Equal as the condition. When you are done, click OK and you will see the six cases we noted previously.Īnother great advantage of using the Standard Filter is the increased flexibility of the Condition criterion. The drop-down just shows every value already existing in the age field, and you may not have the exact number you want in there. Though there is a drop-down for Value, you are better off just typing in 40 here. So on line 3, select “AND” as the operator, “age” as the Field name, “>” as the Condition, and “40” as the value. So, to get the answer we are looking for we need to add one more filter here. The general rule to remember is that using AND reduces the size of your results, and using OR increases the size. But we could have cases that involved females that occurred in other years, or we could have cases in 1978 that involved males. If we selected OR as an operator here, it mean that we would select any case that occurred in 1978, or any case that occurred involving a female. This is one of those things that you cannot do using AutoFilter. But that Operator area is important, since you can also select OR as an operator. Going to line 2, we see one big thing already, which is that there is an operator, and in this case the operator is “AND”. For the first filter it says that the field name of “year” with a condition of “=” and a value of “78” has been selected.
You will see that the filters you already have in place are reflected in this window.
0 kommentar(er)
