How to add a third column to sort in Excel There are very few repeated dates, but there are a few repeated months. Let’s create a new custom sort on three columns: Date, Personnel and Region.

3. Excel removes all years not equal to (Does Not Equal) 2017. 4. Click Clear Filter From Violation Date on the Sort/Filters submenu. 5. On same menu, select MONTH from the Search box dropdown menu.