excelNewbie22
Well-known Member
- Joined
- Aug 4, 2021
- Messages
- 510
- Office Version
- 365
- Platform
- Windows
hi,
i need to know which duplicates there are in col e in combine with cells d1:a1
in order for me mark them all and then delete the duplicates in the entire range e1:a1, e2:a2 and etc
can you please help?
i need to know which duplicates there are in col e in combine with cells d1:a1
in order for me mark them all and then delete the duplicates in the entire range e1:a1, e2:a2 and etc
can you please help?
Cell Formulas | ||
---|---|---|
Range | Formula | |
E1:E8 | E1 | =D1&C1&B1&A1 |