Auto filter in Excel is used to filter out information that you'd like to exclude. As an example, you can filter out specific rows or columns based upon some conditions. Whenever you use the Auto filter, you get a subset of the first values from the table after distinct ranges/columns https://gregoryjylxg.blogadvize.com/41594709/the-ultimate-guide-to-auto-filter