ST Alpha - "Excel smarties, this feature must exist right? -- (edited)" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 156

Excel smarties, this feature must exist right? -- (edited)

Posted by ty97 Nov 3 '22, 12:05

I have a column of data with 3000+ rows. Imagine something like this

11042
11042
11042
18751
23329
23329
30114
55217
55217

Some items repeat (sometimes many times). Other items only appear once.

I want a list of each *unique* value from that column. Whether it appears once, three times, or 100 times, I just want to see it once so that I have a list of each value that exists in the column.

How?

Responses:

Speaking of excel, just saw this a minute ago -- (pic) - Beryllium Nov 3, 12:14 [Attachment]
UNIQUE -- (link) - judge amanda jones Nov 3, 12:06 7
- Remove duplicates....that's so simple that it's genius. - ty97 Nov 3, 12:09 6
  - Additionally If you want to visualize duplicates you can set up conditional formatting with a custom formula - Max Nov 3, 12:14 5
    - 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

Excel smarties, this feature must exist right? -- (edited)

Replies are disabled on threads older than 7 days.