How to Find Duplicate Data in Microsoft Excel

Wondering how to find duplicate data in Excel? This simple formula can save you loads of time by helping you filter and delete duplicate cell data.

There are a number of ways to do this, but I’ve found this to be the easiest way to perform this function, especially if you have hundreds or thousands of cells to analyze.

If you want to simply copy and paste the formula into Excel, I have the entire formula written in a blog post here: bit.ly/1OLvypE

For more Microsoft Excel productivity tips, you can binge-watch the entire playlist here: bit.ly/ExcelHowTo
____________________________________________

Thrive Business Accounting is led by Michelle Mangen, a detail-obsessed numbers maven and financial right hand to successful service business owners.

We support coaches, consultants, digital product and membership sellers, and other small business owners. If you sell high-ticket services or products, accept payments from multiple sources, and you’re just done handling the ins and outs of your bookkeeping…Thrive can help.

Maybe you’re done on a cognitive level: “I don’t know how to reconcile these statements.”
Maybe you’re done on a productivity level: “I don’t have time to run these product sales reports!”
Or maybe you’re done on an emotional level: “If I have to manually re-categorize one more credit card expense, I will break things.”

No matter what made you feel DONE with your bookkeeping, we can help.

If you need virtual bookkeeping and accounting services, click here: thrivebusinessaccounting.com/

Get your ducks in a row with this free bookkeeping checkup:
bit.ly/free_bookkeeping_checkup

Learn how to work smarter with these proven techniques:
bit.ly/work_smarter10

Increase efficiency and reduce errors with Zapier automation:
bit.ly/Zapier_tricks

Follow Michelle here:

Website: thrivebusinessaccounting.com/
YouTube: youtube.com/user/YVAmmangen
Twitter: twitter.com/mmangen
LinkedIn: linkedin.com/in/michellemangen