Finding and highlighting duplicate values with Copilot in Excel

Greetings, We’re continuing our series of posts to show you some of the things that are possible to do with Copilot in Excel. Today I will show you how Copilot can help determine if you have any duplicates in your data and highlight them. I’ll start with a table of employees for Wingtip Toys (fictional).

A table of employees with columns for Name, Address, City, State and Hire date

I ask Copilot in Excel to: Show me if there are duplicates in my data

Copilot in Excel pane showing the above prompt and a response for a conditional formatting rule to review and apply, with a button to apply the conditional formatting.

I apply the rule and my table now has yellow highlights on duplicate values in both the Address and State columns.

A table of employees with columns for Name, Address, City, State and Hire date with duplicate values highlighted in Yellow in the Address and State columns.

I just want to see duplicate values in the address column, so I will undo the changes and ask Copilot to:

just apply formatting to the address column

Copilot in Excel pane showing the above prompt and a response for a conditional formatting rule to review and apply.

After applying the updated conditional formatting, my table now just has duplicate values highlighted in the Address column:

A table of employees with columns for Name, Address, City, State and Hire date with duplicate values highlighted in Yellow in the Address column.

Over the coming weeks I will be sharing more examples of what you can do with Copilot in Excel.

Thanks for reading,

Microsoft Excel Team

*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.