I have an excel table with thousands of rows that are past client purchases. The columns are Client Number, Client Name, GP, Days, GP/Day, Year, and State. The years range from 2013-2017. Because this list is based on purchases, there are client duplicates. I want to remove all client duplicates and their respective rows if the client has purchases in 2017. For example, say there are 3 Wal-Mart rows with different years in each row, if one of these rows has the year 2017 I want all rows containing Wal-Mart removed.
I'm hoping there is a formula for this, any ideas?
Its not a filter because if you filter out the year 2017 there may still be client duplicates with purchases in earlier years.
Bookmarks