#1
|
|||
|
|||
SORT() and FILTER() functions missing
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 |
#2
|
|||
|
|||
also posted at
SORT() and FILTER() functions missing | MrExcel Message Board SORT() and FILTER() functions missing |
#3
|
|||
|
|||
Yes, I just learned about the cross posting rules
|
#4
|
||||
|
||||
I think you need to be an 'Office Insider'. See How to join and use Microsoft's Office Insider program - TechRepublic
The first screenshot on that page shows an Office Insider button (which I don't have (although I have managed to become an Insider)) which you might be able to use in a straightforward way. However, if the button/tile is not there then I can't remember exactly how I did it (3 months ago), but it involved a bit of internet searching and I needed to download an MS application and change a registry settting. I managed to do it without re-installing Office and chose the Current Channel (Preview) option. When I next tried manually to update Excel/Office it gave me the added FILTER, SORT and SEQUENCE functions and more. These sites may give you an inkling of the sorts of thing involved - I went about it with some trepidation and was really quite surprised at how convoluted the whole process was, however, I was lucky and it worked first time: How to enroll in the Office Insider program if you're using Office 365 Enterprise | Windows Central Switching between Microsoft 365 Apps for Business/Enterprise, Current, Preview and Beta Channel (Office Insider) without re-installing - MSOutlook.info |
#5
|
|||
|
|||
Thank you p45cal
it looks like (also as per others replies) that applies only to 365, correct? Or did you find also a way (or different standalone version) to enable it on Excel 2019? Thank you |
#6
|
|||
|
|||
Office 365 only
SORT function - Office Support BTW i can report they are really cool, the only problem is that we are on 2016 at work so i have at least 5 years before i will be able to use in anger! |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Size of filter sort box and open at 1st available row for new data. | mobile | Excel | 0 | 10-23-2016 03:39 AM |
Filter Mail Merge based on a list of filter criteria | AusSteelMan | Mail Merge | 2 | 05-09-2016 03:35 PM |
Filter, Sort, Macro... what to do? | zingle | Excel | 3 | 10-17-2015 06:49 AM |
Forgotten Sort and Filter Criteria | rbdmg | Mail Merge | 0 | 10-31-2011 09:14 PM |
sort & filter icon not available or icon not highlighted | survivo01 | Excel | 1 | 08-08-2011 03:41 AM |