0
0
Excelspreadsheet~10 mins

Removing duplicates in Excel - Real Business Scenario

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Scenario Mode
👤 Your Role: You are a sales assistant at a retail company.
📋 Request: Your manager wants a clean list of unique customer emails from recent orders to send a promotional offer.
📊 Data: You have a list of recent orders with columns: Order ID, Customer Name, Email, and Purchase Date. Some customers placed multiple orders, so their emails appear more than once.
🎯 Deliverable: Create a new list that shows only unique customer emails without duplicates.
Progress0 / 5 steps
Sample Data
Order IDCustomer NameEmailPurchase Date
1001Alice Smithalice@example.com2024-05-01
1002Bob Jonesbob@example.com2024-05-02
1003Alice Smithalice@example.com2024-05-03
1004Charlie Leecharlie@example.com2024-05-04
1005Dana Whitedana@example.com2024-05-05
1006Bob Jonesbob@example.com2024-05-06
1007Eva Greeneva@example.com2024-05-07
1008Frank Blackfrank@example.com2024-05-08
1
Step 1: Select the entire data range including headers (A1:D9).
No formula needed.
Expected Result
The data range with all orders is selected.
2
Step 2: Go to the Data tab on the Excel ribbon and click on 'Remove Duplicates'.
No formula needed.
Expected Result
The Remove Duplicates dialog box opens.
3
Step 3: In the Remove Duplicates dialog, uncheck all columns except the 'Email' column.
No formula needed.
Expected Result
Only the 'Email' column is selected for duplicate checking.
4
Step 4: Click OK to remove duplicate emails from the list.
No formula needed.
Expected Result
Duplicate emails are removed, leaving only unique emails in the list.
5
Step 5: Copy the unique emails to a new sheet or area for the clean list.
No formula needed.
Expected Result
A clean list of unique customer emails is ready for the promotional offer.
Final Result
Unique Customer Emails
----------------------
alice@example.com
bob@example.com
charlie@example.com
dana@example.com
eva@example.com
frank@example.com
✓There are 6 unique customer emails from 8 orders.
✓Some customers placed multiple orders but only appear once in the clean list.
✓This clean list can be used to avoid sending duplicate promotional emails.
Bonus Challenge

Use an Excel formula to extract unique emails dynamically without removing duplicates from the original data.

Show Hint
Use the UNIQUE function like =UNIQUE(C2:C9) to get unique emails in a new range.