Hello sir Ek file me hyperlink ko advance banana hai ,ya to aap is par koi video ho to woh bhej dijiye ,nahi to sir meri ek file hai ,aap us par laga dijiye, please sir Me is file ko leker bhi bahut problem me hu
Thanks for this knowledge. I have one problem if same number or text in multiple column then how can find them like you (B Grocer 1, B Grocer 2..........)
Ma daily basis pay large data excel ma enter krta hn to kya ya search box ma automatically a jy ga ya jo data ply say enter ha ya sirf us k according kam kry ga
amazing, but i had a question to you, I have some data like (06/1SLUB, 6/1SLUB Sp-1, 6/1SLUB Sp-5, 6.5/1SLUB ,07/SLUB SPEC-38, 07/1FSIRO SPEC-3) Now I want, If I type 06/1 then I will show all the data which contain 06/1 and if I type 07 it will show all the data which contain 07 and starting by 07. Is it possible brother if thn how can I do please help me. I don't have filter function.
Sir mera ek table hay jisme helper column ka formula auto expand nahi ho raha hai. Aur helper column me "formula omits adjacent cells" error araha hai. But uska reason nahi pata .
Please advice : I have a excel sheet for my project employees..and I want to make excel sheet in which I can search the employees details by their employee codes..simple If I enter the employee code I want all the details should come on that least...plz help
Very nice and helpful. I have a question - how to show the results of people with the same first or last name example Mike Armstong, Mike Joe? Really appreciate
एक सर्च बोक्स में दूसरी व तीसरी रिपोर्ट सर्च करना हो तो कैसे बनाएं सर्च बोक्स जैसे एक कस्टूर है बी ग्रोसर उसने अलग अलग कम्पनियों का अलग अलग आइटम कई बार खरीदा तो उस कस्टूमर काअलग अलग कम्पनी वाइज एवं अलग अलग आइटम वाइज रिपोर्ट निकालने के लिए वीलुकप से कैसे सर्च बॉक्स बनाई जाती है।
Important Massage:- किसी भी शीट को अगर हम अगली शीट पर कॉपी करते है तब उस शीट के फ़िल्टर Button Automatic छोटे हो जाते है और Micro भी काम करना बंद कर देता है इसके लिए कोई वीडियो बनाई जाये।
Important Massage:- किसी भी शीट को अगर हम अगली शीट पर कॉपी करते है तब उस शीट के फ़िल्टर Button Automatic छोटे हो जाते है और Micro भी काम करना बंद कर देता है इसके लिए कोई वीडियो बनाई जाये।
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](http://i.ytimg.com/vi/gAY9is-ahQY/mqdefault.jpg)
Very helpful vlookup mene kafi istmal kia h mukhtalif tareeqe s ek or col ka milgaya thank
Thanks a lot🌹
How about any column to search? Can you help me? Thanks
Thanks for this video
Me is tyaka data table banane ke liye pichhle tin dinse paresan tha thank you sir.......
You are welcome
its a greate teaching.....in a very good way.... you r really a teacher meterial...
well done
Thanks for your compliment
बहुत badiya सर ,आपकी इस वीडियो की वजह से मेरी बहुत बड़ी प्रोब्लम सॉल्व हो गई ,में बहुत ही preshan था ,आपकी वीडियो देखते ही काम हो गया।👌
Thanks a lot
Hello sir
Ek file me hyperlink ko advance banana hai ,ya to aap is par koi video ho to woh bhej dijiye ,nahi to sir meri ek file hai ,aap us par laga dijiye, please sir
Me is file ko leker bhi bahut problem me hu
Great job really informative for all working in EXCEL U R great Excellent زبردست
Thanks a lot
Greatfull thank you so much for to provide each and single details in this video
Thanks a lot
Very very useful and formative and amazing.
Thanks
Sir, extremely good.But, can you do above video using INDEX+SMALL+IF+ROW function. Or if you have already done, please share link. thank you.
कृपया यह बताने की कृपा करे कि शीट पर हर column ka जॊड कैसे करे.
आप का vidieo मै हमेशा देखता हूँ वाकई मे इस से बहुत हमे फायदा हुआ है.
Thanks for this knowledge. I have one problem if same number or text in multiple column then how can find them like you (B Grocer 1, B Grocer 2..........)
Thanks, it is helpful, but one problem is that after 25 th row it will not show the results if there is lists
Thanks bro for sharing such a wonderful information ❤❤❤
Thank you so much
VERY NICE AND HELPFULL THANKU SIR☺
Ma daily basis pay large data excel ma enter krta hn to kya ya search box ma automatically a jy ga ya jo data ply say enter ha ya sirf us k according kam kry ga
Sir mere gst clients H to kya hume grocer 1 ye sb identity dena jruri H
Excellent Sir
Thanks
Sir second lookup in search bar is not working according to first letter of word search. If possible please guide.
Zabardast sir very beautiful
Thanks
Excellent, even i didnt understand the language, the process was so smooth, you derserve like and subcribe😊
Thanks you so much bro
amazing, but i had a question to you, I have some data like (06/1SLUB, 6/1SLUB Sp-1, 6/1SLUB Sp-5, 6.5/1SLUB
,07/SLUB SPEC-38, 07/1FSIRO SPEC-3) Now I want, If I type 06/1 then I will show all the data which contain 06/1 and if I type 07 it will show all the data which contain 07 and starting by 07. Is it possible brother if thn how can I do please help me. I don't have filter function.
Excellent work Sir 👍
Thanks
Can we apply 2 vlookups for the same cell.. As which shown in your video....
Nice. How about any column to search? Is this possible?
My data file is too long and after putting Vlookup as you suggested My Microsoft is responding very late. How can I speed up
Wonder video sir ji
Thanks ji
very nice Sir
Thanks a lot
Agar customer ka name different different colum me ho with different work to kaise use ek jagh le aye
How about multiple values example b grocer and cooking oil
Search kiye huye data ko mark kar na ho ya edit karna ho to kar sakte hai kya
You can mark but not edit.
Sir mera ek table hay jisme helper column ka formula auto expand nahi ho raha hai. Aur helper column me "formula omits adjacent cells" error araha hai. But uska reason nahi pata .
Hi, how if i wanna show dates in date format ? Thank you
Excellent bro.... Can u help to know if we can do paste value special while we had applied of filter?
Thanks
thank so much
Welcome
Welcome
Love ❤️ you sir
Thank you Rahul
Super
Thanks
Excellent
Thanks
❤❤❤great
Thanks
Hello sir, I need some help on this video, how I can contact you?
Thank you sir , it's very helpful to me
Welcome
This trick really helpful me but I need another 1 trick this sheet final total summery need please help mee
Please advice : I have a excel sheet for my project employees..and I want to make excel sheet in which I can search the employees details by their employee codes..simple If I enter the employee code I want all the details should come on that least...plz help
I can help if you still need that
Greetings to you ♥️🌹🌹 I tried to apply it in Arabic, but it did not work. Please respond in detail.
Sir filtter date range ka v video banao.
Plz create a tutorial on data entery form and search box that we could use on mobiles thanks
how can i creat serch box to serch data bases on date and store type ?
Can you make cheque print excel for different types of bank?
Yes
Product wise search
Bhai koi tarika jo excel may save kiya sim contacts ko save krna ho apny phone may
Sir form se data entry krne ke baad sheet 2 pe jo data aata hai uspe search button wala concept work nhi krta plz help
around 3 min , when u search for e why it returned only B Grocer and didnt returned easy store?
First match will be returned by VLOOKUP. As B Grocer has alphabet e.
Sell ka total kaise lagagega is me
Very nice and helpful. I have a question - how to show the results of people with the same first or last name example Mike Armstong, Mike Joe?
Really appreciate
No issue in this case it will work. The problem will come there when the complete name is same. And that too has a solution.
@@PowerExbyJitendra I got customers with same name as well. I mean One customer is using multiple services. How can we address that?
@@PowerExbyJitendra Also, how to make it work by adding new details from time to time?
एक सर्च बोक्स में दूसरी व तीसरी रिपोर्ट सर्च करना हो तो कैसे बनाएं सर्च बोक्स जैसे एक कस्टूर है बी ग्रोसर उसने अलग अलग कम्पनियों का अलग अलग आइटम कई बार खरीदा तो उस कस्टूमर काअलग अलग कम्पनी वाइज एवं अलग अलग आइटम वाइज रिपोर्ट निकालने के लिए वीलुकप से कैसे सर्च बॉक्स बनाई जाती है।
I try this search box after vlookup drag to all cell come #N/A error
same
Plz sir maine bahut baar mesg kiya aapko ek prog aisa bnaon jis mai new data, edit, delete ,search,view,print jaisa ek data banayenge sir plz
Good job bt is ma gar mazeed data add krna ho to kasy kry add to ho jata ha bt serch ma show nai hota
Is not working with big data like 7/8/9 Lakhs data, any suggestion
Split data or arrange it to alfa order
Sir column function ka koi video bataye. I'm unable to understand this
Ok zaroor
Date kese add kare is search box me
this system apply in google sheet
You can use filter function in google sheets
How to lookup up for data in multiple sheets
I have made a video on it please watch.
@@PowerExbyJitendra link
ruclips.net/video/-X88d_KuCmw/видео.html
When I am putting Vlook it and I enter here comes #N/A
Par sar new entry karne ke baad unique vallue nahi aa rahi hai
Helper collume main
Important Massage:- किसी भी शीट को अगर हम अगली शीट पर कॉपी करते है तब उस शीट के फ़िल्टर Button Automatic छोटे हो जाते है और Micro भी काम करना बंद कर देता है इसके लिए कोई वीडियो बनाई जाये।
Boghas. Dadi shem shem avi Boghas product ni jjaherat na karo pl
Any problem not solved
Drop down list does not work if sheet is protected
Thanks lot
Thanks
Important Massage:- किसी भी शीट को अगर हम अगली शीट पर कॉपी करते है तब उस शीट के फ़िल्टर Button Automatic छोटे हो जाते है और Micro भी काम करना बंद कर देता है इसके लिए कोई वीडियो बनाई जाये।