In this tutorial, I want to show you how you can check for duplicates in your data, and return the list of items that are duplicated. To do this, you can first compare the COUNTA and COUNTA UNIUQE to see if there are any duplicates. If the numbers returned are different, you can then use the FILTER function to return the list of items that are duplicated in the data. I hope that you found this tutorial to be helpful, and if you did please like, subscribe, and comment. Thanks for watching!

#data #datavisualization #msexcel #graph #howto #trending #tutorial #excel #msexcel #wow #tips #tipsandricks #exceltips #excelsettings #finance #excel #pivottables
@LeilaGharani @techteachersandstudents
@freecodecamp @TeachersTech @excelisfun

Keep calm I have a spreadsheet for that tshirt
https://amzn.to/4cSyKNF

Freak in the Excel Sheets?
https://amzn.to/3GoOI33

My Official Patron Page
patreon.com/ExcelTutorials

Get Office 365 https://amzn.to/3sUld5V


Get an amazing new laptop!!
https://amzn.to/3T2ppLu

Have all of the keyboard shortcuts at the tip of your fingers
https://amzn.to/3SSpHof