Reinstecker
Reputation: 47
Excel ignore duplicates and list unique values dynamically
I am looking to remove duplicates from column A and list all uniques to Column B. When more ID's added to column A it should process them automatically
Upvotes: 1
Views: 2580
Answers (1)
Scott Craner
Reputation: 152450
Put this in B2 and copy down:
=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($A$2:INDEX(A:A,MATCH("zzz",A:A)))/(COUNTIF($B$1:B1,$A$2:INDEX(A:A,MATCH("zzz",A:A)))=0),1)),"")
Upvotes: 3
Related Questions
- Ignore Duplicates and Create New List of Unique Values in Excel
- Create a list of the unique identifier for each duplicate value in Google Sheets
- Excel - List return distinct data from other column with duplicate values
- Getting unique values in Excel by using formulas only
- Ignore Duplicates and Create list of Unique Values separated with commas in Excel
- Create list of unique values from a range in Excel
- Unique Values in Excel with dynamic parameter
- Get Unique Value list in excel
- excel unique values
- list distinct values in excel