Unique Function in Office 365 not appearing as option

[IainMB]

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?

Thanks

[#2]

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?

[#3]

@Martin_Weiss All sorted now.  Thanks Martin