Log In
Create Account
SlickerTalk
Search Archives
The Leaderboard
The FAQ
Login
Create Account
Search
Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...
RSS Feed
Hosting by DigitalOcean
Support ST on Ko-Fi
Links Only
50 Results
100 Results
250 Results
500 Results
1000 Results
5000 Results
2 Weeks
2 Months
6 Months
1 Year
2 Years
5 Years
All Time
Live
Down to Post
Backboards:
Live
________________
1: Dec 4, 18:10
2: Dec 4, 12:27
3: Dec 4, 09:36
4: Dec 4, 02:38
5: Dec 3, 14:19
6: Dec 3, 11:17
7: Dec 3, 07:33
8: Dec 2, 17:22
9: Dec 2, 11:48
10: Dec 2, 08:21
11: Dec 1, 17:33
12: Dec 1, 11:23
13: Nov 30, 15:54
14: Nov 30, 09:41
15: Nov 29, 16:44
16: Nov 29, 08:01
17: Nov 28, 16:19
18: Nov 28, 09:42
19: Nov 27, 18:07
20: Nov 27, 12:04
Posts: 156
In response to
"
Excel smarties, this feature must exist right? -- (edited)
"
by
ty97
UNIQUE -- (link)
Posted by
judge amanda jones (aka amanda)
Nov 3 '22, 12:06
(No message)
or make a copy of the range, highlight it, and data --> remove duplicates
(www.listendata.com)
Responses:
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
Replies are disabled on threads older than 7 days.
