delete duplicate values

nasir

New member
Joined
Feb 25, 2014
Messages
4
Reaction score
0
Points
0
hi

I have this table. there are some duplicate values in the 1st column, but other does not, I want to delete not just that duplicate value but the whole row where the duplicate email can be found, is this possible?

emailfirst namelast name
akappel@mysunrise.chMélanieKappel
ranipia@hotmail.comGaborLuka
bernard.reber@img.comMarlisSteiner
a.klaus@klausadvisors.chAnitaKlaus
c.nater@finatex.chClaudiaNater
bernard.reber@img.comBarbaraStuder
bernard.reber@img.comMichèleReber
c.nater@finatex.ch
Béatrice
Kühni
please help me.

thank you
Rabeya
 
Select the table, then go to Data and select Remove Duplicates. In the popup, uncheck column B and column C, so that only Column A (the column with the duplicate values) remains checked. Then click Ok.
 
Back
Top