Learn

Advanced Filter

Using operators to refine filters

Using operators to refine filters We can further broaden our filters using comparison operators. Previously in this book, we concentrated on the greater than and less than operators. Now, let’s look at a few scenarios where we can encompass the use of two operators, as well as the NOT criteria. We will also explore how […]

Using operators to refine filters Read More »

Filtering using Advanced Filter

Filtering using Advanced Filter In the previous edition of this book, we learned how to set up and manage sorts and filters. Filtering data in Excel allows you to locate data very quickly, as well as eliminating certain choices (text, dates, or values) from a list’s results, or specifying categories of data to get the

Filtering using Advanced Filter Read More »

Share knowledge