About auto filter
See that none of the features require absolute references, since they only exist in one cell, and spill their benefits to neighboring cells.
You can Evaluate two values through the use of the following operators. When two values are in comparison by making use of these operators, the result is ac