Hello,
I am working with a dataset that has about 400,000 rows of data. In that data there are columns that tell me in which city a transaction occurred, and how many transactions occurred on a particular day.
What I want to do is add a variable column that has an IF function (or maybe Countif) so I can filter the entire data set (in my pivot table) by a certain set of cities. The issue is that there about 200 cities that I want to filter on, and when I try to fun the countif functions, my excel crashes.
Any easy way to filter my dataset to only include the 200 or so cities that I'm interested in?
Thanks
Bookmarks