How to Remove Duplicates Value or Text In Ms. Excel Tutorial Urdu / Hindi. HOW TO REMOVE DUPLICATES VALUE & TEXT IN EXCEL SPREAD SHEET?
REMOVE DUPLICATE ROWS FROM A TABLE
Just as you can remove duplicates from any selected data in Excel, you can easily remove duplicates from a table.
1. Click anywhere in the table.
TIP This displays the Table Tools, adding the Design tab.
2. On the Design tab, in the Tools group, click Remove Duplicates.
3. In the Remove Duplicates dialog box, under Columns, select the columns that contain duplicates that you want to remove.
TIP You can also click Unselect All and then select the columns that you want or click Select All to select all of the columns.
NOTE Duplicates that you remove are deleted from the worksheet. If you inadvertently delete data that you meant to keep, you can click Undo on the Quick Access Toolbar to restore the deleted data. You may also want to use conditional formats to highlight duplicate values before you remove them. For more information, see Add, change, or clear conditional formats.
Delete duplicates rows from a sheet.
You can specify which columns should be checked for duplicate information.
1. Open Excel
2. Go to Data Option
3. Go to Data Tools
4. Select Remove Duplicates
5. Final apply and checked for duplicates information
Learn the basics to advance level to improve computer skills with my youtube channel onlinecomputercoaching
Tutorial by: Syed Ayaz Raza
Please watch: "How To Make Multiple Tables In Microsoft Word"
Tags: How to Remove Duplicates Value or Text In Ms. Excel Tutorial Urdu / Hindi, Hi, how, syed, ayaz, raza, youtube, onlinecomputercoaching, excel, hindi, urdu, Microsoft, office, Office, skills, beginner, learn, tips, remove duplicates in excel, microsoft excel, duplicates, remove duplicates in excel 2013, remove duplicates in excel 2016, remove duplicates in excel not working, remove duplicates, removing duplicates, how to find & remove duplicates record in excel, remove duplicate data, excel remove