AutoFilter allows you to “filter” out only the information you want to see in an Excel workbook. You can filter data for particular text or numbers, filter for the highest or lowest numbers, or create your own custom filters to find ranges of numbers, text inside other text, and more.  

Go to Data > Filter > AutoFilter, and Excel will add drop-down arrows to the first cell in each column of data in your sheet. When you click on any of those drop-down arrows, Excel will display a list of the unique entries in that column.  Learn more…