SORT() and FILTER() functions missing

Ricko_uk

New Member
Joined
Aug 22, 2020
Messages
9
Office Version
  1. 2019
Platform
  1. Windows
Hi,

I have the latest Excel version and fully up to date (just updated it). But the SORT() and FILTER() functions are missing.

How do I enable/install them?

Thank you
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

VBE313

Well-known Member
Joined
Mar 22, 2019
Messages
675
Office Version
  1. 365
Platform
  1. Windows
Check if you need a new update. go to File, Account, and go to Office Updates
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
53,084
Office Version
  1. 365
Platform
  1. Windows
Those functions are only available with 365. So if you are using 2019 (as shown in your profile) you will never get them.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,104
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Please take a minute to read the forum rules on cross-posting, and make sure to follow them in future. Thanks. :)
 

Ricko_uk

New Member
Joined
Aug 22, 2020
Messages
9
Office Version
  1. 2019
Platform
  1. Windows

ADVERTISEMENT

Thank you. What cross posting? I posted only once in this forum. The only other post I made in ExcelForum.com not on this forum...
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,104
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
That is exactly what cross-posting means. If you read the rules, you will understand. ;)
 

Ricko_uk

New Member
Joined
Aug 22, 2020
Messages
9
Office Version
  1. 2019
Platform
  1. Windows

ADVERTISEMENT

Thank you. May I ask what the logic behind that rule is? It makes no sense to me. If you post only in one forum you might be sitting there waiting for ages for a reply.
If you post in more than one you 1) might get answers you would not have received in another forum and get more varies suggestions and 2) get them faster (often time is extremely important)

Thank you :)
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,861
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
Read the rules and you will see a link there explaining the reasoning.
 

Ricko_uk

New Member
Joined
Aug 22, 2020
Messages
9
Office Version
  1. 2019
Platform
  1. Windows
sorry for the silly question, but where are they? I looked for them but could not find them :eek:
 

Watch MrExcel Video

Forum statistics

Threads
1,122,867
Messages
5,598,542
Members
414,245
Latest member
allyciv

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top