fomula UNIQUE

New Contributor

No se porque pero en mi excel no me aparece la formula UNIQUE, ¿alguien sabe por que puede ser?

4 Replies


¿Qué versión de Office/Excel tienes?

@Alvarogf6 Which Excel version are you using? If not any of the ones in the picture below, you can't get it.



Excel 2016


That explains it. UNIQUE is only available in:

  • Excel Online (the browser version)
  • Excel in Office 2021
  • Excel in Microsoft 365

It is not available in older versions such as Excel in Office 2016, and will not be made available in them.