You can also use negative logic, such as all dates that do not equal 2017, or all dates that do not equal March, April, and May. 1. Select the Violation Date field.

If you regularly work with data sets in Excel, you know how important it is to be able to quickly find the information you need.