# Excel UNIQUE Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/excel/unique-function - Author: Better Analyst Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation. [Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst) The UNIQUE function extracts distinct values from a range, allowing for column-wise extraction and exact match options. ```excel =UNIQUE(array, [by_col], [exactly_once]) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the UNIQUE you need in plain EnglishGenerate Formula Need more than a single UNIQUE formula? Try our free [AI for Excel](https://betteranalyst.com/excel-ai) — it reads your entire spreadsheet, answers questions in plain English, and builds charts and analysis in the same chat. ## Parameters **`array`**:\ The range or array from which you want to extract unique values. **`by_col`**:\ A logical value (TRUE or FALSE) that specifies whether to compare values by column (TRUE) or by row (FALSE). The default is FALSE. **`exactly_once`**:\ A logical value (TRUE or FALSE) that specifies whether to return only values that occur exactly once in the array. The default is FALSE. ## What is a UNIQUE Formula in Excel? The *UNIQUE* function in Excel is a powerful tool that allows you to extract unique values from a range or array. It evaluates the specified range and returns a list of distinct values, eliminating any duplicates. In simpler terms, the UNIQUE function helps you quickly identify and list unique entries in your data, making it easier to analyze and understand your datasets. ## A Practical Example Imagine you are managing a customer database for a small business, and you have the following data in an Excel spreadsheet: ### Customer Data Table: | Customer Name | Purchase Amount | Region | | - | - | - | | Alice | 200 | East | | Bob | 150 | West | | Charlie | 300 | East | | Alice | 250 | West | | Eve | 100 | East | You want to find the unique customer names from your database. ## UNIQUE Formula To extract the unique customer names, you would use the UNIQUE formula as follows: ```excel =UNIQUE(A2:A6) ``` ### Breakdown of the Formula: - **A2:A6**: This is the range from which unique values will be extracted. ## Result of the Formula When you apply the formula, it returns a list of unique customer names. The output would be: | Unique Customer Names | | - | | Alice | | Bob | | Charlie | | Eve | Here, the unique customer names are displayed without any duplicates. ## Why Use UNIQUE? The UNIQUE function is particularly useful when you need to analyze data sets with potential duplicates. It allows you to quickly generate a list of distinct entries, simplifying data analysis and reporting. ## Key Takeaways: - **UNIQUE**: Extracts unique values from a specified range or array. - **Efficient Data Analysis**: Helps you quickly identify distinct entries without manual filtering. - **Common Use Cases**: Ideal for customer databases, inventory lists, and any scenario where you need to find unique values. Understanding how to use the UNIQUE function can significantly enhance your data analysis capabilities in Excel, enabling you to extract meaningful insights from your datasets. Happy analyzing! ## Example use case You have a table where Column A contains a list of product names sold in a store, and you want to identify all the unique products that were sold during a specific period. You can use the UNIQUE function to extract a list of distinct product names from Column A. This allows for efficient inventory management and helps in understanding product diversity without the need for complex data manipulation or filtering techniques. **Beyond the UNIQUE function:** Better Analyst is a full [Excel AI](https://betteranalyst.com/excel-ai) that goes well past individual formulas. Upload any spreadsheet and ask questions in plain English — you'll get formulas, data analysis, and charts back in seconds. It's a free [AI Excel assistant](https://betteranalyst.com/excel-ai) that works with any .xlsx, .xls, or .csv file — no plugins, no Microsoft 365 required. Don't have a spreadsheet yet? Use our free [AI spreadsheet generator](https://betteranalyst.com/ai-excel-spreadsheet-generator) to turn a text prompt into a downloadable Excel file — a full [AI Excel sheet maker](https://betteranalyst.com/ai-excel-spreadsheet-generator) that builds headers, columns, and formulas from your description. ## Need more help with Excel formulas? Create a free account for formula help, explanations, and spreadsheet analysis. Usage limits depend on your plan. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Excel how-to guides - [How To Count Unique Values In Excel](https://betteranalyst.com/excel/how-to-count-unique-values-in-excel) - [How To Multiply In Excel](https://betteranalyst.com/excel/how-to-multiply-in-excel) - [How To Password Protect An Excel File](https://betteranalyst.com/excel/how-to-password-protect-an-excel-file) - [How To Remove Blank Rows In Excel](https://betteranalyst.com/excel/how-to-remove-blank-rows-in-excel) - [How To Remove Duplicates In Excel](https://betteranalyst.com/excel/how-to-remove-duplicates-in-excel) - [How To Separate Names In Excel](https://betteranalyst.com/excel/how-to-separate-names-in-excel) - [How To Sort In Excel](https://betteranalyst.com/excel/how-to-sort-in-excel) - [How To Split Cells In Excel](https://betteranalyst.com/excel/how-to-split-cells-in-excel) ## Explore all Excel formulas Browse our complete library of Excel formula guides Compare your options ## Decide with evidence, not a sales pitch. Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose. 1. [01ChatGPTOpen a balanced comparison prompt in ChatGPT.](https://chatgpt.com/?prompt=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 2. [02ClaudeOpen the same research prompt in Claude.](https://claude.ai/new?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 3. [03PerplexityResearch the comparison with linked web sources.](https://www.perplexity.ai/search?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.