ST Alpha - "Additionally If you want to visualize duplicates you can set up conditional formatting with a custom formula " (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 156

In response to "Remove duplicates....that's so simple that it's genius." by ty97

Additionally If you want to visualize duplicates you can set up conditional formatting with a custom formula

Posted by Max Nov 3 '22, 12:14

In google sheets I enter this in the Format Rules. Custom formula is
=COUNTIFS($A$3:$A3,$A3)>1 with a font or fill color

Anything that duplicates something in all the cells above it gets lit up.

I prefer this step first before outright deleting duplicates because there might be some reason I want to keep them.

Responses:

also really god bless google sheets. my company sells google workspace but we don't have accounts so we are not supposed to use google sheets - judge amanda jones Nov 3, 12:16 3
- I usually treat it as my proof of concept test bed before trying to tackle the same thing in excel. -- nm - Max Nov 3, 12:17 2
  - (google sheets test bed is low enough even chubbers could get on it) -- nm - Max Nov 3, 12:18 1
    - Oh chubbers. -- (pic) - Kellyanne Scrabblestats Nov 3, 12:28 [Attachment]
in excel conditional formatting --> highlight cells rules --> duplicate values. -- nm - judge amanda jones Nov 3, 12:15

Post a message top

Additionally If you want to visualize duplicates you can set up conditional formatting with a custom formula

Replies are disabled on threads older than 7 days.