Hello sir , Me MIS EXECUTIVE me work karta hu muje excel me work karna rahta hai isiliye me sabhi Excel sikhye unka videos dekhta hu but aap ka tarika bahut easy hai or jaldi samj aa jata hai
Sir, IAM keep watching your videos ... Sir, would require your expertise here and advise... I am trying to prepare one formula which can output best 50 results simultaneously out of 10k on the basis of there past and current ratings.
Have u updated to office 365 insider program..if yes then do file -> account -> office insider -> change channel then select i agree and ok..you will get filter Formula
Videoबहुत ही अच्छा लगा।धन्यवाद। searchable ड्राप डाउन का अब तक का सबसे सरल,short औऱ बेहतरीन वीडियो है। please help me..... परन्तु एक समस्या है।जब मैं final formula filter...(टाइप कर रहा हूँ तो रिजल्ट में "this function is not valid" आ रहा है
Thank you Abhay so much for your comment, however this is quite difficult in 2007 as this can be done by new Formulas only.. however i will still try on that..
@Gyan On Tube Thanks a lot for the quick response. I am a follower from Bangladesh & I believe that each of your videos on RUclips is unique. So I never miss any video. Thank you sir.
Thankyou for your superb video but ek cell ke liye to thik hai lekin jab me ise niche ke or cell ke liye drag karta hu to ye kaam nahi karta hai uske liye kya karna chahiye
good morning sir i want that with the help of drop down list the whole sheet or selected data can be changed and in its place other data will come please send video related to it
I have query sir - multiple products eg ; eyeliner , mascara, in one column there Sales are also given in another column with names of salesperson & in the date column its in calender year format , so through drop down for year 2004, 2005 ,2006 how will will populate the sales of each product by each person ? If we select 2004 we will get sales of each product by each salesperson....
Thanks for the video. Kindly advise how we can apply this to different cells. For example I have to search and find at position A5 which gives all names against the letter given at A5. Now at A6 am searching for another name. How we can make it possible???
FILTER function seems inactive in Office 365 and once I type FILTER it showing invalid and FILTERXML is popping up while typing only "filter". How to fix this!
Neilesh sanghrajka ye abhi sirf office insider program mein hi available hai..but bahut jald Microsoft isse rollout kar dega..if u want filter Formula then you need to install new office insider program
Thanks a lot bro, It's a very easy way for searchable drop Down list. May i use it multiple cell as using "cell" formula in seentext "find text". hope you will reply me. I'm from Dhaka Bangladesh.
Hello Mohammad, hope you are well..you can give a try and hope it will work on multiple cell..if not let me know i will prepare another video on the same.
Ye filter formula abhi sirf office 365 mein available hai..agar aapke pass old version ka excel hai to usme ye Formula show nhi karega...magar aap online Microsoft mein jaake ye use kar sakte ho..
Brother aisa posible hai k agar ham kuj search kare or uske related jo b value ho wo apke G coulam k bajaye drop-down ke neche vale cell me populate ho, jaise hum google me search karte hai to wo uske related value show krta hai ????
Alauddin liton , can you tel me which version of Microsoft you are using..as of now filter Formula is only available in Microsoft office insider 365..you can upgrade your office
Very nice question mac, so you mean only letter which is starting in man..and if man is comming in between so it should no popup.. correct..yes will try this as well
Hello sir ,
Me MIS EXECUTIVE me work karta hu muje excel me work karna rahta hai isiliye me sabhi Excel sikhye unka videos dekhta hu but aap ka tarika bahut easy hai or jaldi samj aa jata hai
Thank you so much
Saw many videos but yours is most easiest and convenient!
Thanks for making this video
Thank you so much 🥰
Really Great and Helpful video sirji..TQ
Aapke comment ke liye bahut bahut shukriya
Very good.
Thank you sajid kayani ji for your valuable comment
Very nice searchable data validation formula thank you sir
Thank you so much pramod ji..share zaroor karna video ko
Thanks a lot for such a brilliant tutorial . Very helpful.
Thank you Rajeev for your comment..do not forget to share this video
It's so easy and useful. Thanks a lot for this brilliant post.
Thank you kazi for your valuable comment.. please do share this video with your friends who want to learn excel
Very Very nice. I mean unique. Your way of teaching is also superb..Expecting more video even complicated matters with easier process. 👏
Thank you so much..do not forget to share this video
Excellent
Bahut bahut shukriya..do not forget to share this video
Very Nice
Thank you Ram..keep sharing keep learning
Excellent video. Very useful. Thanks a ton. Helped me a lot😊
Thank you so much..do not forget to share this video
Very nice searchable drop-down list function is awesome thank you sir
Thank you so much for your valuable comment...do not forget to share this video..
Superb and small process ,awesome
Thank you Rohit Agnihotri ji..keep supporting 🙏🙏🙏
One of the finest valuable video I have ever found in RUclips
That's buddy for your valuable efforts
May Allah bless you and
Thank you so much for your comment and support 🙏🙏🙏🙏
Thank You Sir 😊😊
Thank you so much
Thank for your valuable inputs.
Thank you so much Millan..do not forget to share this video
Thanks sir I really need this
Thank you so much
Thank you for example in easy way 😁😁
Thank you so much..
Good explanation sir...if i use sort it will show alphabetical order
Yes it will..just give a try
Well explained 👍.. Thanks sir
Thank you so much...do not forget to share this video
Sir your videos are really helpful for us. Became a fan of yours. The way you explain its really amazing ....
Nileshgiri goswami ji..your comments are very valuable to me..🙏🙏... request you to please share my videos with your fiends and family..
Sir, your videos are unique and has a lot of info.
Thank you so much vinod for your valuable comment..keep sharing and keep learning..
Sir, IAM keep watching your videos ... Sir, would require your expertise here and advise... I am trying to prepare one formula which can output best 50 results simultaneously out of 10k on the basis of there past and current ratings.
You can connect on my telegram page someone can definitely help you there
@@GyanOnTube
Does this work in old versions too?
No filter function is only available in office 365
NICE TRICK 🤩
Thank you so much
Simple and very useful
Thank you so much
Very good sir.
Thank you so much Cumaar S ji..keep sharing keep learning
Very good knowledge. Please upload video how can do same thing in VBA code
Thank you Sunil ji..as soon as i am done with my Power BI module we will prepare vba codeing video for you
@@GyanOnTube thanks
Awesome!!
Thank you so much..fo not forget to share this video
sir searchable data validation drop down list multiple cell and sheet per video banaye please
Sure point noted
Super duper, good explanation
Bharat kumar ji.. thank you so much for your valuable comment... please support and share the video with friends and family
My excel sheet is macro enabled file so this not taking filter instead filterxml
Akshay Rankhamb ji ye filter formula sirf office 365 mein available hai abhi..these are new Formulas..
Hello,
Excel 365 showing formula "FILTERXML" while formula "FILTER" not showing.
Please help on it
Have u updated to office 365 insider program..if yes then do file -> account -> office insider -> change channel then select i agree and ok..you will get filter Formula
@@GyanOnTube same issue im not using 365
ruclips.net/video/EKKFLt5ItKc/видео.html
hi sir - I have Excel 2019 - there FILTERXML function only available, but FILTER function not available, please explain.
Data Validation isn't working with # in my system, I am using Office 2016
Kindly upgrade your excel to 2019 ot 365
Video is great n Unq like You sir...
Thank you so much
sir!
how to mak this for entire column, not for only a single cell (i want to use it in an entire column not in only a single cell)
I have one more video for this which will be for entire column..
ruclips.net/video/hiLRwD9WQ9s/видео.html
Thanks sir
Ravindra yadav ji aap logo ki comment aur support ki waja se hi esi videos bana pata hu.. please isko share zaroor karna
very great
Lucky bi need ur support.. please share the videos yo your friend and family..so everyone can gain knowledge..
The filter function is available in only Office 365. So it will not work in older versions up to 2019...
Yes correct..
Sirji this video is very helpful to me. Can you plz tell how to apply searchable down down list in multiple column.
Very nice question Hitesh ji..i will prepare a video on it as well
Gyan On Tube sir ji did you upload this video
Videoबहुत ही अच्छा लगा।धन्यवाद। searchable ड्राप डाउन का अब तक का सबसे सरल,short औऱ बेहतरीन वीडियो है। please help me.....
परन्तु एक समस्या है।जब मैं final formula filter...(टाइप कर रहा हूँ तो रिजल्ट में "this function is not valid" आ रहा है
Aapke pass kaunsa version hai excel ka kiyoki ye abhi sirf office 365 mein hi available hai..
Reply के लिए धन्यवाद।मेरे पास office 10 है। क्या इसका कोई solution है ।
Iske liye filter function hona bahut zaroori hai..aap online excel ka use kar sakte hai jo bilkul free hai
It's very easy, and please add practice file on Dicrpiton
Sure will do that in some time
It's to easy and short methods but not working in excel 2010.
For this you need to have upgrade Microsoft office 365
Sir multiple colomn say 1 say ziyda cell kasay search karain gay. Is per video banain. Thanks
Nice suggestion..sure iske liye bhi work karta hu..
hi, friend, very useful, thanks
Thank you sadiq ji..keep supporting keep sharing
Formula k liye thank you...per aapne yeh nehi bataya...k iss drop down ko multiple cells may karna ho toh kaise kare
Uske liye mene ek aur video publish kar rakhi hai aap wo dekh sakte hai
good
Thanks
Great sir.
Ye excel 2013 main searchable detavelidation lag sakta hy ....
Ya ni plz guide Regard
Nhi only in office 365
❤
Thank you
Thanks sir.
But filter function is not available in office 2013 help.
It is only available in office 365 as of now
Hi , I liked it and thanking you. One request can it be made possible in Excel 2007.
Thank you Abhay so much for your comment, however this is quite difficult in 2007 as this can be done by new Formulas only.. however i will still try on that..
ruclips.net/video/EKKFLt5ItKc/видео.html
This is a great video. Sir, how to do this without office 365? Thank you.
As of now we do not have any option
@Gyan On Tube Thanks a lot for the quick response. I am a follower from Bangladesh & I believe that each of your videos on RUclips is unique. So I never miss any video. Thank you sir.
Thank you so much 🥰
Is number ke pahile filter formula nahi aa raha he to kya karana he ?
Sagar ji aap kaunsa excel ka version use kar rahe hai..kya wo office 365 hai
Macro ka video share kariya sir...begginer to advance
Sure will prepare a series for that as well
If you type any word then drop-down list become auto populate without click on filter.
Shekhar pal ji unable to understand your question
FILTER OPTION IS NOT COMING IN FORMULA BAR
Hi Husain ji its only available in office 365 now but soon it will rollout thought out Excel..
Hi , Can you pls help me in searchable dropdown new ? I want same like D3 in D4, D5,D6,D7,D8
Sure Atul ji you can watch my video and prepare as it is..
Good keep it up 👍
Will publish more..stay tuned..and keep sharing the videos
Thankyou for your superb video but ek cell ke liye to thik hai lekin jab me ise niche ke or cell ke liye drag karta hu to ye kaam nahi karta hai uske liye kya karna chahiye
Uske liye let me create a new video
Thankyou ❤❤❤
Hurrah!!!!!
Thank you so much
Show 1 more step that when I write man how it will color the F column?
Nice question chowdhury sunzid ji..sure will work and upload one more video on this
@@GyanOnTube Thanks, it will better if it color the line and take me the cell automaticly which I am searching.
@@chowdhurysunzidmahbub79 sure will work and upload a video soon.. please share the video with your friends and who so every want to learn excel.
We are not find 'Filter Farmula ' in my System. I think it is not activated in my system. Can you help me how it can be activate. Thank so much sir.
Its only available in office 365
good morning sir i want that with the help of drop down list the whole sheet or selected data can be changed and in its place other data will come please send video related to it
Yes that can be done by applying vlookup with the drop list
@@GyanOnTube If you have related video then send it
PLS PROVIDE FILTER OPTION IN EXCEL
Hello Salim, you can download free office 365 and use filter option in excel..
ruclips.net/video/817Z8U2AREw/видео.html
Can you send list of good books for creating bill and searchable drop down in excel.
Books??
@@GyanOnTube yes sir
Filter is not giving up result? Type same formula as u r typing in same type of table.
Please elaborate
Sir can't find FILTER function in my excel, please help
Its only available in office 365 as of now
Is filter function available in MS office 2013 Professional Plus
Altesh its only available in office 365 the latest version of Microsoft excel
ruclips.net/video/EKKFLt5ItKc/видео.html
But wil it work when we paste the drop-down In all down cells
Yes it will work..you van give a try
Sir, when I am using filter function my Excel 16 show function is not valid pls reply
Yes this function is only available in office 365..
sir ho sake to kitchen & wardrobe cutting list software excel me banana sikha de..
Sir i am confused with ur question
I have query sir - multiple products eg ; eyeliner , mascara, in one column there Sales are also given in another column with names of salesperson & in the date column its in calender year format , so through drop down for year 2004, 2005 ,2006 how will will populate the sales of each product by each person ? If we select 2004 we will get sales of each product by each salesperson....
Use if condition with text join function
Waist of time,
I need automatic drop down without click on drop down button.
Sir, frist digit hi show ho????
Agar first ho show karna hai to apply left with find
filter formula is not available in excel 2013. Sir any other formula
Please upgrade your office
Is it possible to copy this searchable dropdown from one sheet to another sheet?
Yes definitely it is possible
Thanks for the video. Kindly advise how we can apply this to different cells. For example I have to search and find at position A5 which gives all names against the letter given at A5. Now at A6 am searching for another name. How we can make it possible???
Unable to understand.. please elaborate
Sir mera Excel may develop tap hai per filter kiu nahi function key show kar raha hai pls replay
Habib khan ji..ye developer tab se nhi aata..you need to have office insider 365 program.
ruclips.net/video/EKKFLt5ItKc/видео.html
FILTER function seems inactive in Office 365 and once I type FILTER it showing invalid and FILTERXML is popping up while typing only "filter". How to fix this!
You need to have office 365 insider program...and then open excel --> click on file --> go to account setting and change that to monthly..
@@GyanOnTube thanks for the info.
ruclips.net/video/EKKFLt5ItKc/видео.html
Can't find filter formula can you please help... I am using microsoft office home & student 2019
Neilesh sanghrajka ye abhi sirf office insider program mein hi available hai..but bahut jald Microsoft isse rollout kar dega..if u want filter Formula then you need to install new office insider program
ruclips.net/video/EKKFLt5ItKc/видео.html
Filter function is not available in my excel what can I do
Which version of excel you are using
Thanks a lot bro, It's a very easy way for searchable drop Down list. May i use it multiple cell as using "cell" formula in seentext "find text". hope you will reply me. I'm from Dhaka Bangladesh.
Hello Mohammad, hope you are well..you can give a try and hope it will work on multiple cell..if not let me know i will prepare another video on the same.
@@GyanOnTube Thanks
I'm unable to find Filter formula in excel, only getting Filterxml
For this you need to have office365 in your system..
How to apply to multiple rows
For that i have published another video
i don't get filter formula option please help...
Filter option is available in office 365 only, which version of excel you are using.
FILTER not show in formula
Ye filter formula abhi sirf office 365 mein available hai..agar aapke pass old version ka excel hai to usme ye Formula show nhi karega...magar aap online Microsoft mein jaake ye use kar sakte ho..
Dear sir, Filter function is not reflect in excel
It is only available in office 365 as of now
my excel don't have "FILTER " formula
plz help
Aap aapne excel ko upgrade kar sakte ho
Sir ji Alphabet ke jaga agar number hoga to ye formula kam korega ?
Hanji kaam karega..
Filter option is not showing in excel...Help sir
Ye abhi sirf office 365 mein hi available hai..
Filter formula is showing invalid in my excel
Are you using office 365 only then you will get filter function.
What if I want this for multiple cells?
I have created another video for this as well
Brother aisa posible hai k agar ham kuj search kare or uske related jo b value ho wo apke G coulam k bajaye drop-down ke neche vale cell me populate ho, jaise hum google me search karte hai to wo uske related value show krta hai ????
Ghuman ji possible zaroor hai check karna hoga..
@@GyanOnTube To me wait kru brother
Sir, which version of this office is it ?
Office 365
Is you provide online VBa training
Nhi vikas ji...i only provide training on RUclips which is absolutely free of cost...
Sir excel 2010 or 2013 mein ye formula kese lage ga?
Uske liye aapko aapna excel upgrade hi karna hoga
why showing filter function is not working bro?
Alauddin liton , can you tel me which version of Microsoft you are using..as of now filter Formula is only available in Microsoft office insider 365..you can upgrade your office
@@GyanOnTube microsoft office 2019 bro
@@alauddinliton5928 aapko upgrade karna parega office 365 insider program
Hi, Is filter formula working in Excel 2016 ?
Donnieds you will only get filter formula in office 365 insider program.
Is it possible...?
If i type 'Man' then it should show me only Manish,Mangesh,mandar etc and not Raman,Azman
Means 'Man' only in first position?
Very nice question mac, so you mean only letter which is starting in man..and if man is comming in between so it should no popup.. correct..yes will try this as well
ड्रॉप डाऊन लिस्ट के फॉन्ट साईज को बड़ा करना है कैसे होगा
Gupta ji control + scroll up kare wo bada ho jaega..
7:00
Ok