UNIQUE
The UNIQUE function in Excel is designed to return a list of unique values from a specified range or array. This is particularly useful when you need to remove duplicates or identify distinct items from a dataset.
| array | The range or array from which to extract unique values. |
| [by_col] | (Optional) A logical value indicating whether to compare values by row or by column. The default is FALSE (compare by row). |
| [exactly_once] | (Optional) A logical value that returns values that occur exactly once in the range or array. The default is FALSE (include all unique values). |
Let's start with a simple example. Suppose you have a list of names in column A, and you want to extract the unique names. Write this formula and give it a range of values and excel will do the heavy work for us.
The UNIQUE function can also be used to extract unique rows from a dataset. And you can create a formula that will return only the unique rows from the specified range.
Obrigado pelo seu feedback!
Pergunte à IA
Pergunte à IA
Pergunte o que quiser ou experimente uma das perguntas sugeridas para iniciar nosso bate-papo
Awesome!
Completion rate improved to 6.67UNIQUE
Deslize para mostrar o menu
The UNIQUE function in Excel is designed to return a list of unique values from a specified range or array. This is particularly useful when you need to remove duplicates or identify distinct items from a dataset.
| array | The range or array from which to extract unique values. |
| [by_col] | (Optional) A logical value indicating whether to compare values by row or by column. The default is FALSE (compare by row). |
| [exactly_once] | (Optional) A logical value that returns values that occur exactly once in the range or array. The default is FALSE (include all unique values). |
Let's start with a simple example. Suppose you have a list of names in column A, and you want to extract the unique names. Write this formula and give it a range of values and excel will do the heavy work for us.
The UNIQUE function can also be used to extract unique rows from a dataset. And you can create a formula that will return only the unique rows from the specified range.
Obrigado pelo seu feedback!
