Maybe this could help some viewers: When entering the array formula in the worksheet, a) highlight the cells for which the filter function holds that is the range area in which you expect your results to appear , then b) click in the Formula Bar (while your cells are still highlighted) and then c) enter the array formula ending with Ctrl+Shift+Enter. It is essential to have all the output cells highlighted first of all. A good practice is that if you intend to function filter e.g a range or a table with rows and columns as input range to set the same size area of the output range , that is the same number of cells (in rows and columns) as the input range
Not working with my office 2019, just like you did I did every thing same way then I press control + shift and enter to generate to keys but is showing all the value but just single value.... please I need help
NOT WORKING SHOWING ERROR. WHEN I PRESS SHIFT, CTRL AND ENTER KEY SIMULTANOUSLY ONLY ROW NUMBER SHOWS. NO COMPLETE DATA IS SHOWN. I AM USING OFFICE 2019.
Sir I am unable to add in filter function in Excel 365 properly.I have added it through the link provided by you but its not showing up in the Excel.Though I can see it in the add-ins list
You guys plz follow the instructions properly without missing any steps, also please use CTRL+SHIFT+ENTER key from your keyboard to generate the array formula, otherwise it’ll return you #VALUE! error
Great video,just had a small query,if i do this add in excel my account will remain safe right?they won't ban my microsoft account for doing this add in I'm new to this so have this small fear
It populates the record but when i used so many rows it shows #N/A after some records, for this I used iferror function but iferror does not show the blank cells, is there anything which i must do.
I can't activate these filter add-ins, when i type =FILTER it still shown =myFILTER, what should i do ? i really need this FILTER function..please help
Thank you from the bottom of my heart for this wonderful and useful video. Thank you for your valuable information, which I benefited a lot from. You made me happy and with your valuable information, I accomplished a lot of work that took me a lot of time.
@@SdMotion already got the SHIFT+CONTROL+ENTER i am facing now is the N/A result even i give it error handling routine like =IFERROR(MyFILTER(A2:H65000,G2:G65000="UnScan"),"") or =IFNA(MyFILTER(A2:H65000,G2:G65000="UnScan"),"") it does not remove the N/A and also i found problem when the result is just only 1 result it give the whole filter select with one result can you help me out thank you advance.
Maybe this could help some viewers: When entering the array formula in the worksheet, a) highlight the cells for which the filter function holds that is the range area in which you expect your results to appear , then b) click in the Formula Bar (while your cells are still highlighted) and then c) enter the array formula ending with Ctrl+Shift+Enter. It is essential to have all the output cells highlighted first of all. A good practice is that if you intend to function filter e.g a range or a table with rows and columns as input range to set the same size area of the output range , that is the same number of cells (in rows and columns) as the input range
How should I do? My excel does not calculate this add ins function . Only show #NAME?
password is missing for macro, the file is protected view....unable to work
why is not working in excel 2019? "#VALUE!"
Not working with my office 2019, just like you did I did every thing same way then I press control + shift and enter to generate to keys but is showing all the value but just single value.... please I need help
same issue
Not working in Office 2019
It s not working in office 2019
It’s giving value error
thnak you very much for your addin, works perfectly!
great shortcuts of Excel
does it work in 2013 excel version?
In MyFILER function "includes" not calculate for ms office 2019
NOT WORKING SHOWING ERROR. WHEN I PRESS SHIFT, CTRL AND ENTER KEY SIMULTANOUSLY ONLY ROW NUMBER SHOWS. NO COMPLETE DATA IS SHOWN. I AM USING OFFICE 2019.
follow the tutorial carefully, and know the arguments sequences properly. This is proven adIns it should work
same error in my office 2019
Same with mine I follow every step, am just getting #value!
sameeee. it's not working. why? because you use the FILTER.. not MYFILTER for your example. emmmmmmmm
IT IS GIVING VALUE ERROR
this is not working
Sir I am unable to add in filter function in Excel 365 properly.I have added it through the link provided by you but its not showing up in the Excel.Though I can see it in the add-ins list
Works with Excel 2010 after CTRL+SHIFT+ENTER to convert to an array formula
Myfilter has value error how should I use
Pls required adds filter function to office 2019 (32bit).its Not working with my office 2019,
Thank you so much!
not working in ms excel 2016
What of I do have the filter function?
Hello sir, can u give sequence formula also
Not working my filter
I downloaded filter function add in but not working in excel 16
Same here not working with =myfilter option
You guys plz follow the instructions properly without missing any steps, also please use CTRL+SHIFT+ENTER key from your keyboard to generate the array formula, otherwise it’ll return you #VALUE! error
how to use excel by extracting data between 2 dates
Great video,just had a small query,if i do this add in excel my account will remain safe right?they won't ban my microsoft account for doing this add in
I'm new to this so have this small fear
No worries
will this filter addin work in excel 2007
It populates the record but when i used so many rows it shows #N/A after some records, for this I used iferror function but iferror does not show the blank cells, is there anything which i must do.
شكراً جزيلاً
Donload file not worked. "This file type is not supported in protected view."
I can't activate these filter add-ins, when i type =FILTER it still shown =myFILTER, what should i do ? i really need this FILTER function..please help
You have to use =myFILTER not =FILTER option
@@SdMotion thank you for your respond.
and how about the formula ? it will be the same like =FILTER function ? or have another formula ?
MyFilter function is not working in excel 2019
Where is the file
If this works thanks a lot. I'll try it
Not work this Y? How to add this excel 2007
Fir me always it says #value! How to fix it
Please follow the instructions carefully!
it run correctly for excel 2016. I press and hold SHIFT+ CONTROL+ENTER keys and return only one value. Please check your code VBA
You have to select multiple ranges to populate the values
sir not working in my Excel
This is great, Only one thing the array is not dynamic, is there a way the range displays all data and no repeat etc
Thank you
You're welcome
Thanks for sharing 🔗👍
it didn't populate the complete record set, just showing the single value. using excel 2016
Use CTRL+ SHIFT + ENTER Key to generate the array formula
not working
Thank you from the bottom of my heart for this wonderful and useful video. Thank you for your valuable information, which I benefited a lot from. You made me happy and with your valuable information, I accomplished a lot of work that took me a lot of time.
It’s means allot to me happy to help you!
showing security concerns....cant add it
Please give let function, lamda, scan, torows, tocol functions
Nice
not working in ms excel 2016
not working in ms excel 2019😤😡😢😩😫
Not working in ms office 2016
what is the password to the VBA if i want to change the name from MyFILTER to FILTER ?
where is the download for the filter function? are there other downloads for other new functions
Please check the link in the description, please follow my channel for more functions.
Not working office 2016
create a video using excel 2016 so we can see if that really works?
Press and hold SHIFT+ CONTROL+ENTER keys to activate the array formula
@@SdMotion already got the SHIFT+CONTROL+ENTER i am facing now is the N/A result even i give it error handling routine like =IFERROR(MyFILTER(A2:H65000,G2:G65000="UnScan"),"") or =IFNA(MyFILTER(A2:H65000,G2:G65000="UnScan"),"") it does not remove the N/A and also i found problem when the result is just only 1 result it give the whole filter select with one result can you help me out thank you advance.
not working in excel 2021
Not working
Please use SHIFT + CONTROL + ENTER TO generate array formula
Not wrk brother ms office 2007
Pls do needful for Vstack function.
Thanks in advance.
Keep in touch
❤❤❤bro
Thank you
But how handle #N/A from the rows
you can use IFERROR function to handle #NA() Errors
@@SdMotion I used it but same problem
doesn't work unfortunately
Watch the video carefully, and follow the same.
Not Working for Excel 2016.
once you have done with the formula, press CTRL+SHIFT+ENTER to convert to an array formula
@@SdMotion I GETT ITTT..TQQQQQ
send new IMAGE function add-in
send me add -in file
Perfect! Please also share excel file..
#VALUE! please tell how to do this?
Press ctrl+shift+enter key to create an array formula
Why only one column reflects but other column has same first column
#NAME?, how to fix?
Make sure the Function add-ins is enable after the installation , or maybe the formula syntax were not used properly.
@@SdMotion can it work in 2019 excel version?
Will support for any version but understand and implement the steps carefully
send filter function add-ins which support office 2019
Once you have develop the formula use SHIFT+CONTROL+ENTER key from your keyboard to generate an array function. Then it will work
Not working showing Error .When I press shift , ctrl and enter key simultanously .
@@SdMotion but then it is only showing single data that to in a single cell and not whole data set
is not working in 2016 excel
please watch entire video carefully
not working
if you’re using old excel version Please use CTRL+SHIFT+enter to activate the function