While the regular filter sorts the data in place, you can also use the advanced filter in Excel to copy the info to a different location. You can use more complex criteria when using the Excel advanced filter.