Best Offer for Books in Amazon

Showing posts with label Remove duplicate values in excel sheet. Show all posts
Showing posts with label Remove duplicate values in excel sheet. Show all posts

Friday 5 May 2017

How to Remove duplicates Values

Hi...Readers !


 In this lesson I am going tell you remove duplicate values from the excel data. Lets see how to do this.


1. select entire Table -> data -> Remove Duplicates


2. Click to 'Select All' Button -> Ok.

Now, It removes row 6, because row 1 and row 6 are same. so it removes only row 6.


Thank you.
Excel Tips

 

How to Protect sheet in Ms-Excel

STEPS:  1. OPEN Ms-Excel 2. Go to Review-> Protect Sheet -> Protect sheet  3. enter Password -> Re-enter Password-> save.