I hope someone can help me. What I am trying to do is remove all of the unique values from a spreadsheet. Or alternatively, remove the duplicates but for them to be saved into another sheet. Any suggestions?
I have identified the duplicate values and they are now highlighted, but when I try to custom sort by cell colour or by font colour, the system just fails. I have tried on numerous PCs and also in online excel and on the regular version