we all finds many duplicated in our excel data sheet but we can also remove these duplicated by using this method so yeah guys in this article we will talk about how to remove duplicates in excel
how to remove duplicates in excel
i will tell us some of the very easy steps so you can remove duplicates from your excel sheets and also these steps are really so simple anybody can do these steps
first of all open your excel sheet or make a new on as i have taken my sheet from my keyword researching data.
now if you select the all columns and do this deleting duplicate method then the excel will match just match the each row and then delete the whole row and
if there is not duplicate row section then you will see the message like this
and if you select a particular column and then do this process then excel will find the duplicates which are present on that particular row and then
it will delete the duplicates and just show you the items elements which are different and also it will manage other columns with these short elements.
so let’s continue our process
now go to the “data” section and click on “remove duplicates” and open it
you will see that each column is selected now select the one column in which you wanted to remove the duplicates and i have mentioned above what will happen if you select all the columns
click on unselect and select a particular column and click on “OK”
if there is any duplicates then excel will filter them and just show you the unique ones.
here you done with finding non-duplicates on your excel project now if you got some kind of help from this content please consider subscribing,
so i will catch you in the next one till then,
you can also read these: