We can take out the filter by any of the two options to make use of the filter and get the data again in the original format. For example: a column that contains names could be filtered by People made up of “A” or “B”, that means Andrew and Bob https://codyrspmk.dm-blog.com/34114454/the-ultimate-guide-to-auto-filter