Remove duplicates

[aghaffar82]

Hello Experts

I am wanting to get rid of duplicate entries that are scattered all over the sheet and intend to keep the left-most as a unique value. so far example if there is a name appearing 3 times in the whole data set, I would like to keep the name that appears in the left-most column.

A small sample is attached for your kind reference and expert look: in the example below, I would like to delete the cell/content B13, D17 & E10.

Sample 5000 Rows-v2.xlsx
	A	B	C	D	E
1	parrot	christy	tara	hot	fab
2	jp	josh	fan	pat	adi
3	ag	cham	gem	dan	asdq
4	Singh	lav	besty	zu	rathore
5	benjamin	ana	far	ange	begood
6	jo	luca	ismil	ingrid	hx
7	joseph	kalr	derr	soy	val
8	ricky	mare	tan	ivan	alfonso
9	patty	vlo	servis	zully	marey
10	euro	qtm	udi	itson	ana
11	Ali	night	mosses	andre	midnight
12	matt	day	gaby	pam	keo
13	danny	jo	jon	saif	char
14	nina	farrukh	eve	dery	mouad
15	prism	sam	hach	tania	khalid
16	tiger	barry	floot	blush	wrath
17	cat	dia	holk	sam	divine
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:E17	Cell Value	duplicates	text	NO

 

[aghaffar82]

Hello Sirs,

This issue has been resolved on another forum and here is the link to the post. Thank you to everyone who chipped in. Regards