Forum Discussion

Jungwoo_Kim's avatar
Jungwoo_Kim
Copper Contributor
Sep 30, 2022

Excel Flatten function not working and not existing

Hi,

 

I'm trying to user Flatten Function and it seems like it doesn't exist.

 

And it is showing as #NAME?. I wonder what is issue.

 

my Excel versions is students version.

 

is there anyone can help me?

 

Thank you.

excel
Formulas and Functions

3 Replies

  • JoeUser2004's avatar
    JoeUser2004
    Bronze Contributor
    Sep 30, 2022

    Harun24HR  wrote:  ``Use TOCOL() function in Excel. ``

     

    But beware:  according to the TOCOL help page (click here}:

    😞

    (Office Insider Beta only)
    Windows: 2203 (Build 15104)
    Mac: 16.60 (220304)

     

     

    • Harun24HR's avatar
      Harun24HR
      Bronze Contributor
      Sep 30, 2022
      Microsoft releases all new formulas fully to Excel for web as well as Current Channel (Not only BETA Channel).
  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Sep 30, 2022
    FLATTEN is not excel function. It is google sheet function. Use TOCOL() function in Excel.

Resources