•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to pull a list of each unique number from sheet with many duplicates
I know I must be missing something super simple. I need to pull out a list of each unique ID number present in a sheet where many ID numbers are repeated multiple times across different columns and rows.
I’ve tried to use =unique a couple different ways on the entire table/sheet to pull out a list, but it doesn’t work. It returns results that reduce the number of IDs, but has duplicates and presents them in a table like format.
I just want a list of every ID that’s present, no duplicates.
Thank you
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#financial modeling with spreadsheets
#unique
#ID number
#duplicates
#list
#sheet
#=unique
#columns
#rows
#table
#results
#unique list
#extract
#format
#present
#data