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
When data base has more than one row, filtered result is correct; but when database has only one answer whole range marked for filter result is populated with the same. Please guide.
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
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
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.
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 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
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.
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
on excel 2016 usully give me #value error , onse i did ctrl+shift+enter it's gave me one cell result. please any advice. thank you very much
In MyFILER function "includes" not calculate for ms office 2019
password is missing for macro, the file is protected view....unable to work
When data base has more than one row, filtered result is correct; but when database has only one answer whole range marked for filter result is populated with the same. Please guide.
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
How should I do? My excel does not calculate this add ins function . Only show #NAME?
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
unable to resolve "#value!" error. If i check in the evaluation, it calculates properly but final result is #value. Not sure, what else can be done.
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
why is not working in excel 2019? "#VALUE!"
great shortcuts of Excel
thnak you very much for your addin, works perfectly!
Hello sir, can u give sequence formula also
Works with Excel 2010 after CTRL+SHIFT+ENTER to convert to an array formula
does it work in 2013 excel version?
Pls required adds filter function to office 2019 (32bit).its Not working with my office 2019,
Thank you so much!
What of I do have the filter function?
will this filter addin work in excel 2007
Myfilter has value error how should I use
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
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 ?
It’s giving value error
If this works thanks a lot. I'll try it
how to use excel by extracting data between 2 dates
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
Thanks for sharing 🔗👍
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
Not work this Y? How to add this excel 2007
MyFilter function is not working in excel 2019
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.
not working in ms excel 2016
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.
what is the password to the VBA if i want to change the name from MyFILTER to FILTER ?
Please give let function, lamda, scan, torows, tocol functions
Pls do needful for Vstack function.
Thanks in advance.
Keep in touch
this is not working
Donload file not worked. "This file type is not supported in protected view."
Thank you
You're welcome
IT IS GIVING VALUE ERROR
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!
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.
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 my filter
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
sir not working in my Excel
Where is the file
❤❤❤bro
Fir me always it says #value! How to fix it
Please follow the instructions carefully!
Not working in ms office 2016
Not working office 2016
Nice
not working in ms excel 2016
not working in ms excel 2019😤😡😢😩😫
showing security concerns....cant add it
Perfect! Please also share excel file..
not working in excel 2021
Not wrk brother ms office 2007
send new IMAGE function add-in
not working
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
#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
doesn't work unfortunately
Watch the video carefully, and follow the same.
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
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