Creating a list of unique values out of duplicates
Hello!
Basically, I have a column with thousands of rows, and many of them are repeated. I want to create a list out of that column that only includes one version of each of the duplicates. Below is a screenshot of exactly what I need:
example1.PNG
I tried using conditional highlighting, but all it does is highlight the duplicates.
Select your data.
Select your data tab
Click on remove duplicates
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Easiest solution. Copy the column to desired location, select the column and go to Data tab and "Remove Duplicates".
There are other ways to do this, but will depend on how you want to use the end result etc.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks