Office Insider Fast and Dynamic Arrays

Copper Contributor

Hello,

 

I’m trying to find the =filter() function, but cannot. please help. I’m running Excel for Mac, version 16.30 (19092600) with an O365 sub. I don't think I have access to Dynamic Arrays, even though the Microsoft blog said that all Insider Fast users now have access. I've tried to re-install Office twice, to no avail. Please help! 

 

Thank you

2 Replies

@Cyrus1300 Same setup as you. Works fine for me. Just start typing "=filter(" and the  function specifics come up automatically.

Thanks, I've tried typing =Filter, =xlookup, changing the color of my tabs - none of these seem to work for me. Thanks

 

@Riny_van_Eekelen