Chidi's team wants to validate the system's duplicate detection against name patterns visible in the data — and quantify how many name matches are coincidental (real different people sharing names) versus genuine duplicates the system has caught.

In the Customers sheet of Meridian_Data.xlsx:

- Add a column called Name Match Count using COUNTIF on the Full Name column to count how many times each name appears - Apply conditional formatting to highlight rows where Name Match Count > 1 in red - Add a column called Verified Duplicate that returns TRUE when Name Match Count > 1 AND is_duplicate = TRUE

Create a new sheet called Duplicate Summary with these five metrics, each calculated using COUNTIF or COUNTIFS: - Total customers - System-flagged duplicates (is_duplicate = TRUE) - Customers w…