Oct 25 2018 08:27 AM
Hello everyone
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
Thanks
Oct 25 2018 08:52 AM
Hi Arron,
Please follow the below trick which rely on the conditional formatting.
Oct 25 2018 09:07 AM
Also, you can use Get & Transform Tool (aks as Power Query) as the below GIF.
Oct 26 2018 01:17 AM
Thank you so much for this. I can't seem to get the arrow to appear next to where it says 'values' at the top?
Thanks
Oct 26 2018 03:19 AM
Hi Arron,
This is the AutoFilter arrow.
To activate it, select the Values column, then click Data > Filter or press Ctrl+Shift+L.
Hope that helps