Removing duplicates in Google Sheets - Dashboard Guide

Dashboard Mode - Removing duplicates

Goal

Find unique customer names from a sales list by removing duplicate entries.

Sample Data

Order ID	Customer Name	Product	Amount
101	Alice	Notebook	15
102	Bob	Pen	5
103	Alice	Marker	7
104	Charlie	Notebook	15
105	Bob	Pen	5
106	Diana	Folder	10

Dashboard Components

• Unique Customers List: Shows only one entry per customer name.
  Formula: =UNIQUE(B2:B7)
  Output: Alice, Bob, Charlie, Diana
• Total Sales Amount: Sum of all sales amounts.
  Formula: =SUM(D2:D7)
  Output: 57
• Total Sales by Unique Customers: Sum of sales amounts for unique customers (first occurrence only).
  Formula: =SUM(FILTER(D2:D7, MATCH(B2:B7, B2:B7, 0)=ROW(B2:B7)-ROW(B2)+1))
  Output: 42

Dashboard Layout

+----------------------+---------------------+
| Unique Customers List | Total Sales Amount  |
|       (List)          |      (KPI Card)     |
+----------------------+---------------------+
| Total Sales by Unique Customers (KPI Card)       |
+--------------------------------------------------+

Interactivity

Adding a filter by product (e.g., only 'Pen') updates the Unique Customers List and both Total Sales KPIs to reflect only sales of that product.

Self Check

If you add a filter to show only orders where Product = 'Pen', which components update and what are their new values?

• Unique Customers List: Shows Bob only
• Total Sales Amount: 10
• Total Sales by Unique Customers: 5

Key Result

Dashboard shows unique customers from sales data and compares total sales with sales from unique customers only.