My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Filter Syntax error|General Excel Questions & Answers|Excel Forum|My Online Training Hub

You are here: Home / Filter Syntax error|General Excel Questions & Answers|Excel Forum|My Online Training Hub

vba course banner

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
Filter Syntax error
Avatar
David_Ng
Member
Members
Level 0
Forum Posts: 306
Member Since:
December 5, 2016
sp_UserOfflineSmall Offline
1
May 18, 2020 - 4:18 pm
sp_Permalink sp_Print

Can someone help to fix the Syntex error for a simple Filter

Avatar
Philip Treacy
Admin
Level 10
Forum Posts: 1529
Member Since:
October 5, 2010
sp_UserOfflineSmall Offline
2
May 18, 2020 - 5:48 pm
sp_Permalink sp_Print sp_EditHistory

Hi David,

You haven't said what the problem is.  Are you receiving an error message?

It works fine for me so I'm not sure what to say.

Maybe reviewing the function syntax will help you figure out whatever issue it is?

https://www.myonlinetraininghu.....r-function

Regards

Phil

Avatar
Purfleet
England
Member
Members


Trusted Members
Level 4
Forum Posts: 414
Member Since:
December 20, 2019
sp_UserOfflineSmall Offline
3
May 18, 2020 - 5:50 pm
sp_Permalink sp_Print

Seems to work for me

What version of excel are you using? Filter is only availible in Office 365

filterworking.pngImage Enlarger

filterCompat-1.pngImage Enlarger

sp_PlupAttachments Attachments
Avatar
David_Ng
Member
Members
Level 0
Forum Posts: 306
Member Since:
December 5, 2016
sp_UserOfflineSmall Offline
4
May 18, 2020 - 6:14 pm
sp_Permalink sp_Print

I got it cause of error,  because I am still using Office 2010, thanks Purfleet.

Avatar
David_Ng
Member
Members
Level 0
Forum Posts: 306
Member Since:
December 5, 2016
sp_UserOfflineSmall Offline
5
May 18, 2020 - 6:23 pm
sp_Permalink sp_Print

BTW, is it possible to use in Office 2010?

Avatar
Purfleet
England
Member
Members


Trusted Members
Level 4
Forum Posts: 414
Member Since:
December 20, 2019
sp_UserOfflineSmall Offline
6
May 18, 2020 - 7:41 pm
sp_Permalink sp_Print

Afraid not.

There are formulas that will do simular but can be fairly complex. Depending how often you will be doing the filter you can just use normal filters or Advanced filters and copy over the data.

Not great but does work

You could create a macro that does a simular thing if you have to do it regularly

Purfleet

Avatar
David_Ng
Member
Members
Level 0
Forum Posts: 306
Member Since:
December 5, 2016
sp_UserOfflineSmall Offline
7
May 19, 2020 - 9:33 am
sp_Permalink sp_Print

Thanks Purfleet, any macro samples can share for filter dataset?

Avatar
Philip Treacy
Admin
Level 10
Forum Posts: 1529
Member Since:
October 5, 2010
sp_UserOfflineSmall Offline
8
May 19, 2020 - 12:32 pm
sp_Permalink sp_Print

Hi David,

We don't know how you intend to use the data so before you go writing VBA, why not use filters as Purfleet suggests?

See attached.

regards

Phil

Avatar
David_Ng
Member
Members
Level 0
Forum Posts: 306
Member Since:
December 5, 2016
sp_UserOfflineSmall Offline
9
May 19, 2020 - 5:25 pm
sp_Permalink sp_Print

Thanks Philip support, agree that's the easy way out.  

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: John Kobiela, Lia Ro, Malcolm Sawyer
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 216
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Melanie Ford
Isaac Felbah
Adele Glover
Hitesh Asrani
Rohan Abraham
Anthony van Riessen
Erlinda Eloriaga
Abisola Ogundele
MARTYN STERRY
Rahim Lakhani
Forum Stats:
Groups: 3
Forums: 24
Topics: 6356
Posts: 27793

 

Member Stats:
Guest Posters: 49
Members: 32324
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen