Ravi Sir's Cards › Excel
Slicer vs UNIQUE + COUNTIFS
Revision card: Slicer vs UNIQUE + COUNTIFS. Example data table with Slicer: click Dairy: 1 row (Milk); List of categories: Fruit, Dairy, Snacks; Count the category in B1: 2.
Read card text
What this card says
Slicer vs UNIQUE + COUNTIFS
Example
data table with Slicer: click Dairy: 1 row (Milk); List of categories: Fruit, Dairy, Snacks; Count the category in B1: 2
Learn this in the lesson: How to Use Slicers in Excel Tables: Insert, Multi-Select, Clear Filter and Arrange Buttons in Columns (with UNIQUE and COUNTIFS)