Excel Flatten function not working and not existing

Occasional Visitor

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.

3 Replies
FLATTEN is not excel function. It is google sheet function. Use TOCOL() function in Excel.

@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)

 

 

Microsoft releases all new formulas fully to Excel for web as well as Current Channel (Not only BETA Channel).