Count duplicate values | remove duplicates | find unique values | excel repeated values

In this video i am using a short function to count duplicate or repeated values as well as unique values in excel and remove these duplicate or unique values. for this purpose i will use countif function and set a condition to find the duplicate values or unique values with the number of time they repeated or unique.

Most of times by copying data there may be duplicate values or repeat values which needs to be removed as duplicates or there may be some unique values which you may want to filter out from data, but manually finding duplicate values of unique values in excel there may be some chances of mistake. but by countif function you can count all duplicate values and unique values and remove these duplicate or uniqu values if there is any duplicate value or repeated value comes in your data or you want to extract unique values from your data.

this video will cover the following topics:
1-count duplicate values in excel
2-remove duplicate values in excel
3-repeated values in excel
4-unique values in excel
5-find single values in excel
6-highlight unique values in excel
7-duplicates in excel
8-find duplicate enteries in excel
9-repeative enteries in excel.

#exceltips
#exceltipsandtricks
#exceltricks
#youtubeviralvideo
#excellearning
#msexceltipsandtricks
#msexceltips
#excelinhindi
#easyexcelgyan
#easyexcel