HDTutorial
EN

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to find duplicate value in excel | Tamil | Excel training in Tamil

21,950 views 6:21

Watch on YouTube
ChannelMyOfficeWork

Chapters

Description from the creator

These are 3 easy ways to remove duplicates in your data to create a unique / distinct list of values in Microsoft Excel. It's a very common task for data cleaning and also a very common job interview question. One of the solutions (removing duplicates with power query) returns a different result to the other methods. I'll explain what the difference is and what to watch out for.

Timestamps
00:00 Introduction
00:36 Conditional Formatting
02:45 How to use COUNTIFS formula to find duplicate
05:08 How to Remove Duplicate

Let’s connect on social:
Instagram: instagram.com/tamilexcel
Facebok: facebook.com/tamilexcel
LinkedIn: at.linkedin.com/in/tamilexcel

#MsExcel

About this tutorial

MyOfficeWork published this 6:21 video tutorial. It has been watched 21,950 times on YouTube.

Duration
6:21
Views
21,950
Likes
339

Tags

Share

This tutorial in other languages