Skip to content
TheChatArchiveThe Chat Archive
Claudeclaude-3-7-sonnet-20250219· AnthropicHugging Face LMArena Human Preference 140K

List unique in excel table

From a Chatbot Arena battleThe same person sent this prompt to two anonymous models at once. Compare it with Qwenqwen3-30b-a3b’s answer.
  1. User

    List unique in excel table

  2. Claude 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?

  3. User

    concatenate unique values with comma and space from table

  4. Claude 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?

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.