Project
Meridian Retail Co. · Excel · beginner
The brief
Before my investor meeting I want to say exactly how many duplicate customer records are muddying our counts. In the data file, the customers sheet has an is_duplicate column. Use a counting formula to count how many rows are flagged as duplicates, and how many are clean. The two numbers should add up to the total row count. Show me all three.
Independent grading
97/100
Achieved 30 Oct 2026
Graded automatically against a fixed rubric for this task. Feedback and submitted work remain private to the analyst.
What is DataSimHQ?
A practice platform where analysts complete graded business tasks for simulated companies in SQL, Power BI, and Excel, and build a portfolio of proven work. Learn more