Forum Discussion

IainMB's avatar
IainMB
Copper Contributor
Oct 11, 2022

Unique Function in Office 365 not appearing as option

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

 

excel
Formulas and Functions
office 365

2 Replies

  • Martin_Weiss's avatar
    Martin_Weiss
    Bronze Contributor
    Oct 13, 2022

    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?

     

Resources