00:00It's a pretty well-known fact that filter function is only available on Microsoft 365 and Excel 2021 onwards.
00:06If you have anything older than that, well, you're pretty much out of luck.
00:09But you can get around it using VBA. Allow me to demonstrate.
00:12On your workbook, you're going to press alternate F11 to open VBA editor and paste this VBA script.
00:18If you need a copy of this VBA script, please leave a request on the comment section and I'll show
00:21you how to get it.
00:22After that, press Ctrl S to save and close your VBA editor.
00:25Now let's do some testing.
00:26I have also included Excel's filter function output here for comparison purpose.
00:30To achieve the equivalent functionality of Excel's filter function with our function, we would say equal filter sign at.
00:37The first argument will be the data cell itself.
00:39The second argument will be the column of where you can find the condition.
00:42The third argument will be the condition itself.
00:44And the fourth argument will be the operator.
00:46And you can see the result is exactly the same.
00:48If we change the brand, those two tables updates accordingly.
00:51We can also use various conditional operators like greater than, greater than equal to, less than, or less than equal
00:56to.
00:56Over here we are filtering for any shoe sizes greater than 13.
00:58Over here we are filtering for any shoe sizes greater than 13.
00:59We'll see you next time.
Comments