I have a dataset with 2 columns, Site and Year. The Sites are labelled 1A, 2D, 3J and so forth. Values from the Sites (such as 1A) are distributed in year 2014, or 2015, or 2016, etc. (many Site values in many years). I want to select sites from year 2015 (1E, 1J) and remove them from subsequent selections (by site or by year) until I choose to return them to the dataset. I've attached my data as well as the pivot table. Thank you!

Attached Files

Manipulate data in pivot table.xlsx (15.2 KB, 11 views)