Removing duplicates in Excel - Dashboard Guide

Dashboard Mode - Removing duplicates

Goal

Find unique customer names from a sales list to avoid counting duplicates.

Sample Data

Order ID	Customer Name	Product	Amount
1001	Alice	Apples	50
1002	Bob	Bananas	30
1003	Alice	Oranges	20
1004	David	Apples	40
1005	Bob	Grapes	25
1006	Eva	Bananas	35
1007	Frank	Oranges	45

Dashboard Components

• KPI Card: Total Orders
  Formula: =COUNTA(A2:A8)
  Result: 7
• KPI Card: Unique Customers
  Formula: =COUNTA(UNIQUE(B2:B8))
  Result: 5
• Table: Unique Customer List
  Formula in C11: =UNIQUE(B2:B8)
  Shows list of unique customer names: Alice, Bob, David, Eva, Frank

Dashboard Layout

+----------------+------------------+
| Total Orders   | Unique Customers  |
|     (KPI)     |      (KPI)        |
+----------------+------------------+
|       Unique Customer List       |
|            (Table)               |
+---------------------------------+

Interactivity

If you add a filter by product (e.g., show only orders with 'Apples'), the Total Orders and Unique Customers KPIs update to count only filtered rows. The Unique Customer List table also updates to show unique customers from filtered data.

Self Check

If you filter the data to show only orders where Product = 'Bananas', which components update and what are their new values?

• Total Orders: 2 (orders 1002 and 1006)
• Unique Customers: 2 (Bob and Eva)
• Unique Customer List: Bob, Eva

Key Result

Dashboard shows total orders, unique customers count, and a list of unique customer names from sales data.