Excel, how to find duplicates by names in a selection of rows
The rows or selection can contain names but also other (different) information but the name is the value that needs to be searched to find a duplicate. It’s hard to explain so I will show it with an example:
How to delete duplicates in two columns where its for a situation where unique values will be in each cell
enter image description here