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
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
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.
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.
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
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
great shortcuts of Excel
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
thnak you very much for your addin, works perfectly!
In MyFILER function "includes" not calculate for ms office 2019
why is not working in excel 2019? "#VALUE!"
It’s giving value error
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
this is not working
Thank you so much!
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
If this works thanks a lot. I'll try it
IT IS GIVING VALUE ERROR
شكراً جزيلاً
Hello sir, can u give sequence formula also
does it work in 2013 excel version?
Myfilter has value error how should I use
Not working my filter
Thanks for sharing 🔗👍
Donload file not worked. "This file type is not supported in protected view."
not working in ms excel 2016
Works with Excel 2010 after CTRL+SHIFT+ENTER to convert to an array formula
Pls required adds filter function to office 2019 (32bit).its Not working with my 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
What of I do have the filter function?
❤❤❤bro
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
Thank you
You're welcome
how to use excel by extracting data between 2 dates
This is great, Only one thing the array is not dynamic, is there a way the range displays all data and no repeat etc
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.
Nice
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
will this filter addin work in excel 2007
MyFilter function is not working in excel 2019
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 ?
sir not working in my Excel
Not work this Y? How to add this excel 2007
Please give let function, lamda, scan, torows, tocol functions
Where is the file
showing security concerns....cant add it
not working
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.
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
Fir me always it says #value! How to fix it
Please follow the instructions carefully!
what is the password to the VBA if i want to change the name from MyFILTER to FILTER ?
Not working office 2016
Not working in ms office 2016
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 in ms excel 2016
not working in ms excel 2019😤😡😢😩😫
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!
not working in excel 2021
Pls do needful for Vstack function.
Thanks in advance.
Keep in touch
Not wrk brother ms office 2007
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.
Perfect! Please also share excel file..
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.
send new IMAGE function add-in
send me add -in file
#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
#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
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
Please use SHIFT + CONTROL + ENTER TO generate array formula
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
not working
if you’re using old excel version Please use CTRL+SHIFT+enter to activate the function