I have a large set of data (40k entries).
The columns include Account ID, Associate, Order Description, Date and Time.
There are several Account IDs. Each is linked to one Associate. However, the Associates have various Account IDs to service.
I need to generate a report/export data/filter out all the entries that have given criteria.
The tricky thing is my criteria list is also rather long. I have about 100 total possible conditions, so I need all entries that have a given Order Description AND a specific order date. There are 100 totals sets of criteria.
What would you advise would help me do this? How do I filter with many conditional filters? It isn't as simple as clicking the filters I want from each column because 1. the column value must also go with another column value and 2. There are so many possibilities.
Ie. I don't want to generate a list of all orders with Order Description - blueberries, oranges, apples, etc. I want to generate a list of all orders with Order Description blueberries on March 1, 2016, oranges on April 3, 2017, oranges January 5,2017, apples March 10,2017.
Solved by F. F. in 19 mins