SOLVED

Not able to use unique formula in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-3284494%22%20slang%3D%22en-US%22%3ENot%20able%20to%20use%20unique%20formula%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3284494%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20use%20unique%20fromula%20but%20it%20is%20not%20working.%20Screenshot%20attached.%20Please%20assist.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22kartikgandhi09_0-1649857900558.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F363826i0F37E91A35D4A0C4%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22kartikgandhi09_0-1649857900558.png%22%20alt%3D%22kartikgandhi09_0-1649857900558.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3284494%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3284877%22%20slang%3D%22en-US%22%3ERe%3A%20Not%20able%20to%20use%20unique%20formula%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3284877%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3Bokay.%20%3CLI-EMOJI%20id%3D%22lia_neutral-face%22%20title%3D%22%3Aneutral_face%3A%22%3E%3C%2FLI-EMOJI%3E%20Thank%20you%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3284643%22%20slang%3D%22en-US%22%3ERe%3A%20Not%20able%20to%20use%20unique%20formula%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3284643%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1362459%22%20target%3D%22_blank%22%3E%40kartikgandhi09%3C%2FA%3E%26nbsp%3BThen%20you%20will%20not%20have%20it.%20An%20upgrade%20to%20MS365%20or%20Excel%202021%20is%20required.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3284632%22%20slang%3D%22en-US%22%3ERe%3A%20Not%20able%20to%20use%20unique%20formula%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3284632%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%20Excel%202019%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3284538%22%20slang%3D%22en-US%22%3ERe%3A%20Not%20able%20to%20use%20unique%20formula%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3284538%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1362459%22%20target%3D%22_blank%22%3E%40kartikgandhi09%3C%2FA%3E%26nbsp%3BWhat%20Excel%20version%20are%20you%20on%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3284517%22%20slang%3D%22en-US%22%3ERe%3A%20Not%20able%20to%20use%20unique%20formula%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3284517%22%20slang%3D%22en-US%22%3EJust%20curious%2C%20usually%20%22INT%22%20shows%20in%20the%20%22Name%20box%22%20when%20we%20type%20a%20formula%20%3F%3C%2FLINGO-BODY%3E
New Contributor

I am trying to use unique fromula but it is not working. Screenshot attached. Please assist.

 

kartikgandhi09_0-1649857900558.png

 

5 Replies
Just curious, usually "INT" shows in the "Name box" when we type a formula ?

@kartikgandhi09 What Excel version are you on?

best response confirmed by Hans Vogelaar (MVP)
Solution

@kartikgandhi09 Then you will not have it. An upgrade to MS365 or Excel 2021 is required.

@Riny_van_Eekelen okay. Thank you