Forum Discussion
EricPatterson
Microsoft
Aug 30, 2024Finding 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 dupl...
m_tarler
Aug 30, 2024Bronze Contributor
thank you for all these tips but in this tip you said COUNTING and highlighting but I don't see any counting. I ask because I created a nifty LAMBDA to return duplicates (as opposed to UNIQUE) and can set the # duplicates it looks for. So I was curious if there was a nifty way to count duplicates (other than the way I came up with).