List unique in excel table
- User
List unique in excel table
Assistant
To find unique values in an Excel table, use the UNIQUE function:
=UNIQUE(range)For example, if your data is in cells A1:A20, you would use:
=UNIQUE(A1:A20)Would you like me to explain how this function works or share alternative methods for finding unique values?
- User
concatenate unique values with comma and space from table
Assistant
To concatenate unique values from a table with commas and spaces between them, you can use a combination of UNIQUE and TEXTJOIN functions:
=TEXTJOIN(", ", TRUE, UNIQUE(range))For example, if your data is in cells A1:A20:
=TEXTJOIN(", ", TRUE, UNIQUE(A1:A20))This will give you a single cell containing all unique values from your range, separated by commas and spaces.
Would you like me to explain how this formula works?
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.