Unique Function in Office 365 not appearing as option

Copper Contributor

Hi - I've been trying to access the Unique function on Excel and despite downloading the latest version on Office 365 it still doesn't appear as an option in the formula drop downs?  When I type it into a formula I just get #NAME?.  Any ideas?




2 Replies

Hi @IainMB 


it should appear in the Lookup & Reference function group:



Could you provide a similar screenshot of your Excel? What does it look like?


@Martin_Weiss All sorted now.  Thanks Martin