Home

Removing unique values

Arron Godfrey
New Contributor

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

4 Replies

Hi Arron,

 

Please follow the below trick which rely on the conditional formatting.

 

RemoveUniqueValues.gif

Also, you can use Get & Transform Tool (aks as Power Query) as the below GIF.

 

RemoveUniqueValuesUsingPowerQuery.gif

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

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies