Replacing function Filter.

[Habiler]

Hallo everybody,


After a change of pc I have another version of office 365. I had a formula that worked flawlessly

Please Login or Register  to view this content.

Is now

Please Login or Register  to view this content.

the current version of 365 no longer supports the FILTER function;

hOW CAN I REPLACE THE FUCTION filter() ,

tHANKS FOR ALL

hABILER

[AliGW]

Office 365 DOES support the new dynamic array formulae. I would check that your Office installation is completely up-to-date first.

File | Account | Office Updates.

[Habiler]

The update of my office is ok. Its the 365 from my office.

Can you help me by replacing the formula with Filter() ?

Thanks for all

Habiler

[Habiler]

hELLO?

i tried this and thats OK

Please Login or Register  to view this content.

HOow to display the two columns of "T_"&B5&"" and those with column 1 > a C35 and C35-1 if it does not exist.

The formula with filter is

Please Login or Register  to view this content.

[XOR LX]

Office 365 DOES support the new dynamic array formulae. I would check that your Office installation is completely up-to-date first.

Hi Ali,

I assume the OP requires that any solution work in their desktop version of Office 365.

I have Office 365, though, due to my particular subscription, functions such as FILTER, SORT and UNIQUE will not be rolled out to me until this July. Until then I can continue to use those functions in Excel Online, though not in my desktop version.

Regards

[RaulSerg]

Check under ACCOUNT whether you're subscribed for the Insider Channel.

Depending on your account, maybe you just need to sign in again?

[Habiler]

Dear all,

wITH MY personal office 365 its ok. But the version of my effice dooesnt supprt the Filter() function


Habiler