Hello. How do I PULL OUT the duplicates in a list. Not just remove them. Or it could be highlighted too. Grazie.
Hello. How do I PULL OUT the duplicates in a list. Not just remove them. Or it could be highlighted too. Grazie.
Two ways...
- Data tab >> Data Tools >> Remove duplicates
- Data >> Sort & Filter >> Advanced >> Copy to another location >> List Range: (Select the range) >> Copy to: (Pick a cell for the output) >> Check Unique records only
There are other ways, but these two are probably the most straight forward without a formula or VBA
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks