aghaffar82
Board Regular
- Joined
- Jun 13, 2019
- Messages
- 65
- Office Version
- 365
- Platform
- Windows
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.
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 |