How to Find and Remove Duplicates in Excel एक्सेलमध्ये डुप्लिकेट कसे शोधायचे आणि काढायचे.

Hello everyone, it's me Deepali..

Welcome to my channel Excel Tutions with Deepali...

Use conditional formatting to find and highlight duplicate data. That way, you can review the duplicates and decide if you want to remove them.
Step 1: Select the cells you want to check for duplicates.

Step 2: Go to the Home tab and click on the Conditional Formatting .

Step 3: go to the Highlight Cells Rules and click on the Duplicate Values in the drop-down list.

Step 4: Then, a Duplicate Values box appears. In the box next to values with , pick the formatting you want to apply to the duplicate values.

Step 5: And then click on the ok button.

Follow the following steps to remove duplicate rows by using this command.

Step 1: Select a cell inside the data from which you want to remove duplicates data.

Step 2: Go to the Data tab.

Step 3: And click on the Remove Duplicates command button.

Step 4: Excel will then select the entire set of data and open up the Remove Duplicates window.

Step 5: Once you have ensured that the required fields are checked in the dialogue box, click on the ok button.

How to Find and Remove Duplicates in Excel :-https://youtu.be/gB4hbKbaboc

Then please join me on my channel.

So lets learn together.

Official Facebook Account : https://www.facebook.com/share/15iyLRUKAt/
Official Telegram Account : https://t.me/ExcelTutionWithDeepali

Видео How to Find and Remove Duplicates in Excel एक्सेलमध्ये डुप्लिकेट कसे शोधायचे आणि काढायचे. канала Excel Tution With Deepali