How to filter in Excel by copying the filtered data to a new location without doing anything to the original data set. This method leaves the original data set intact without changing it or hiding any rows in order to perform the filter.
This requires a few steps that can be confusing if you have never used the advanced filter features of Excel but, once you learn them, this type of filter is pretty easy to perform.
Download the spreadsheet that accompanies this tutorial to try this out.