Log In
Register
Home
December 5, 2016
Offline
Can someone help to fix the Syntex error for a simple Filter
October 5, 2010
Offline
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
Trusted Members
December 20, 2019
Offline
Seems to work for me
What version of excel are you using? Filter is only availible in Office 365
December 5, 2016
Offline
I got it cause of error, because I am still using Office 2010, thanks Purfleet.
December 5, 2016
Offline
BTW, is it possible to use in Office 2010?
Trusted Members
December 20, 2019
Offline
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
December 5, 2016
Offline
Thanks Purfleet, any macro samples can share for filter dataset?
1 Guest(s)
