A SECRET WEAPON FOR AUTO FILTER

Use AutoFilter or constructed-in comparison operators like "larger than" and "top 10" in Excel to point out the information you need and conceal the rest. As you filter data in A selection of cells or desk, you are able to both reapply a filter to get up-to-date final results, or very clear a filter to redisplay most of the details.Note: Some poli