FILTER

[JoseRamonLagos]

I nee to know why FILTER in same spreadsheet can work in one computer and not in other. Both computer have Office365 installed.

Thanks.

[#2]

@JoseRamonLagos 

And both are on same channel and same version of Office365? 

[#3]

Web has translate your msm automatically to Spanish, so not sure what you mean with "same channel?". REgarding version of Office365, not sure if they have same version, but function could stop work with differente version of Office365???

[#4 · Accepted solution]

@JoseRamonLagos 

Office365 subscriptions is distributed by channels and within them by versions. In general FILTER() shall be available for all channels but semi-annual version 1908. You may check that in File->Accounts, it looks like

[#5]

@Sergei Baklan Thanks!

[#6]

Sergey, I have Office professional 2016 version 2105, but filter does not work. 

[#7]

@David565 

Based on screenshot you are on Excel 365. It shall work here, in Russian locale that's ФИЛЬТР(). 

Функция ФИЛЬТР - Служба поддержки Office (microsoft.com)

[#8]

I dont know... it does t work

[#9]

@David565 

Nope, that's another function. 

What is your subscription, is it business, home, student, whatever ? It shall be here

And why did you decide you are on Office 2016 Pro?

[#10]

@Sergei Baklan 

[#11]

@David565 

Oops, I forgot 2016 also could be with C2R installer. If that's 2016 when no way, FILTER() and other related to dynamic arrays functions are on subscription model (Excel 365) only.

These days build number means practically nothing. It could only indicate if code for this or that functionality is included into the build. But that doesn't mean that functionality will be activated.

[#12]

But I installed Office 365