Unique Function in Office 365 not appearing as option

New 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?

 

Thanks

 

2 Replies

Hi @IainMB 

 

it should appear in the Lookup & Reference function group:

Martin_Weiss_0-1665644469730.png

 

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

 

@Martin_Weiss All sorted now.  Thanks Martin