How to ignore hidden values of a filtered data while computing Sum, Average in Excel in Hindi
Special Offer for First Time Users
If you are the first time user and want to learn Microsoft office skills, then you can avail this special offer discount on your email.
For quick filtering, do this:
1. Click the arrow Filter drop-down arrow in the table header of the column you want to filter.
2. In the list of text or numbers, uncheck the (Select All) box at the top of the list, and then check the boxes of the items you want to show in your table.