Another way to hide rows in Excel tables so that the AGGREGATE function only includes what's showing is by inserting slicers, interactive buttons that you can click to make filtering much more ...