I have an excel workbook which contains 400 sheets. Every sheet has required data in A1 to A10 cells... Is it possible to extract A1 to A10 data of all sheets in a single column of a master sheet? So that A single list is formed which contains all data of all 400 sheets😊
I needed help. And I contact Sir. He responded right away and helped me so professionally and effectively. I am also moving forward with joining his online classes. He saved me for whole week. Thanks
Hi bro, I have 2 sheets , in one sheet I have 3 columns and in sec sheet I have 2 columns, so here if the 1 and 2 column data are same , then the data from 3rd column, sheet 1 should be pulled to sheet 2 column 3, how to do that
i want a solution for similar data of two column in such a way that similar data of two coloumn placed automatically in front of second column and mis matched data will placed below this is there any formula for this?
I have one doubt. Column index number should be 2 because "Emp code" is in column 2 then how come you typed column index number as 1 and it gave accurate result?
i have two spared sheets one is called stock with price and another is called calculator in a stock sheet there is 3 columns category and sub category and price that shows in calculator sheet in list form i am not able to get a specific price of category and subcategory wise ex fruit is category and apple is sub category and 100 is price in calculator sheet fruit and apple are showing but how can i get the price of it please help me............ looking to hear from you..
Ek chese btao agr present sheet me mera kuch data match nhi h ot hm vlookup lga rhe h or jo match data nhi h uski jagah NA naa aa k jo available h present sheet me wo aae toh kaise karinge
Mere paas 10 sheets me alag alag date me data hai, usko hume singke sheet me kisi specified dates me daalna hai, means jo bhi duusri sheet me data ho, new sheet me sirf wahi data aae jis date ka hum chahte hai... Ye kaese ho paega? For example ; 18 years ka complete daily data hai and humko sirf weekday ka lena hai.. To aese me holiday and Saturday sunday ka data nahi chahye... To ye kaese karege
I need your help.... Mere pass ek master data hai ...... Usmain device name k according two different entries hai .... Only device name comman hai .....mera pass kuch names hai devices k but main chahta hu ek formula lagau ki toh rows mil Jaye mujko device name k according. Suppose 1000 students ka data hai, usmain se student name comman hai bahut se student ka, assume 100 students hai jinka naam comman hai others 100 students se ..... Name k alava baki sabhi value alag hai jaise enrollment no., Class , age. Mujko bas name k according data extract karna or duplicate wallo ko bhi lekar aaana hai ager hai vaha toh
If value will be repeat then you have to summarize your data first then apply because all the lookup function give first search result, it wouldn’t go down
sir kya aap mujhe ye bta jaise ye jo do sheet hai aise meri bhi do sheet hai ..lekin frist sheet pr meri code name or qunty three column h same doosari sheet par hai..lekin frist sheet k anusar doosari sheet pr code name qunty nhi wo uper neeche likhe huye hai. ab dono sheet match kaise karaun same code same. name aaye
3.00 par ye data apka sheet one par hai toh vo kis row par hai kaise pata kare without Ctrl+f se with formula se kaise pata Karen jab 20k data hai aur usme formula lagate highlight ho gaye
Conditional formatting condition ke base per formatting karta hai Aur lookup formula dusre sheet or workbook se value ko fetch karta hain And formula always will be automation whenever new data come it will work Conditional formatting Aur lookup formula mein Jamin aasman ka fark hai
bro jaisa ki ak line me name h Aakash and wo 2-4 line chodkar fir aa rha h and aise hi chal rha h or bich m sare name b ase mix h to kya hume un sabko aksath kr sakte h? jaise Aakash ki jitni row h wo sari ak sath. plz help
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](http://i.ytimg.com/vi/gAY9is-ahQY/mqdefault.jpg)
The one more method is to use filter in any tsble and data is ctrl+shift+l if we use this shortcut so our work will be done fast 😊
कैसे
Me aap Ki sari video dekhti Hu 👌💝
Thnks dear don't forget to share
So what 😅😅
Thanks for the amazing explanation!
Hi Abhijeet bhai , Very informative and Helpful video
Bahut bahut dhanyawad...I will always greatful to you
Wlcm and keep in touch to learn more
Bhai apne ne to system phar diya ❤❤❤
Bohot pasand aaya video 👍👍👍👍👍
Thank you sir aap bahut achche se samjate ho👌👌👌👌
Bahot badhiya sir ji.
Wlcm keep in touch to learn more
It's one of the best video I have seen regarding two sheets comparison...great job👌👍👍
Thnks
You made my day bro
Impressive way to teach....way to go buddy...
Thank you broooo this is best video ❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤ thanks
Wlcm
Superb Abhijeet bhai, guys saved this video. its very damn important topic which can be asked in interview.
Wlcm
Wants to filter a data can u help
I have an excel workbook which contains 400 sheets. Every sheet has required data in A1 to A10 cells... Is it possible to extract A1 to A10 data of all sheets in a single column of a master sheet? So that A single list is formed which contains all data of all 400 sheets😊
Amazing Content Thats Great
Thank you for your knowledgeable information it's really saved my day ❤
great job bro, u really saved my time
Thnks and keep in touch and learn more
Bhai apka ka to system heee@@AbhijeetjiTechnical4M
This video helped me, thank you
Today it is saved my 2 hours of working
Thanku.... I just resolved my isuue
very helpful video. great
Thank you so much sir❤❤
Very well explained 👍
Super job 👍
This is really helpful thanks
Thank you bro ❤
Thank you bro, this is the video I was looking for .
Thanks for this information 👌
Wlcm
Very honestly shared
Thank you🙏
Thank you sir.
Excellent bro
1st comment, spr video sir ji 👍👍👍👍🙏🙏🙏
Sir,same prblm match formula se bhi nikal jayegana ?
Yes nikal jayega Thnks dear don't forget to share
@@AbhijeetjiTechnical4M sir,ek query dha, macro with multiple sheet kaise hoga ,pls make a video sir
Thanks 👍
Thank you sir aap bahut achche se samjate ho 😊❤️
Tq sir 🙏🙏
Thank you so much 😊🙏🏻
You're welcome 😊
Thank you sir
Thanks bhai
Thankyou bhai🙏🙏🙏
Wlcm don't forget to share
Hi Abhijeet, This video is very helpful for us. Could you please tell me that how to compare two workbook in VBA ???
Aapki pivot table bali playlist se mene bhut imporove kiya h...is there more vidoes about pivot table ...pls share if any...wonderful playlist
No but will come
Well explained 👍
Thanks don't forget to share
Excellent always
Thnks don't forget to share
if we want to write something like Done in formula cell if match data found ?
Then use if condition like if(isnumber(vlookup formula),”Done”))
Thank you sir
Most wlcm dear
nice information
I needed help. And I contact Sir. He responded right away and helped me so professionally and effectively. I am also moving forward with joining his online classes. He saved me for whole week. Thanks
Can you please explain why we put the 1 after comma
For approximate match you have to put 1
Nice bhai
Hmmm nice gaming videos bhi banao😂
Thanks for
If we have to match multiple workbook
Compile all workbook data at one place and apply vlookup otherwise one by one you can apply vlookup
Last year kash mai ye video dekh liya hota to job se hath nahi dhona padhta 😔❤️
यह libre office excel मे भी काम करेगा क्या
Yes
Thanku
Hi bro, I have 2 sheets , in one sheet I have 3 columns and in sec sheet I have 2 columns, so here if the 1 and 2 column data are same , then the data from 3rd column, sheet 1 should be pulled to sheet 2 column 3, how to do that
Simple apply vlookup where available only 2 columns
🎉🎉
thanks
Wlcm
🎉🎉❤❤
Supper bro
Plzzz tell how to use v lookup for more than one columm
Vlookup video available on my channel go to advance Excel formula playlist and watch
Brother, I want to know that if one sheet has 30 employee codes and the other sheet has 50 employee codes, then how will we match 30 with 50?
Apply vlookup in 50 sheets data , you will seen some result will come with na error that means those values not available in sheets 1
i want a solution for similar data of two column in such a way that similar data of two coloumn placed automatically in front of second column and mis matched data will placed below this is there any formula for this?
Explain pls
Bhai jab data sequence me na ho tab ye kam karenge ya nahi?
Yes karega
i am not gettting NA but also not total value and records match sheet 1(604) & sheet 2 (601) what can I do
You are doing some mistake watch carefully and apply
Google sheets and excel sheets are same ???
Yes mostly functions are same
@@AbhijeetjiTechnical4M thankyou so much
I have one doubt. Column index number should be 2 because "Emp code" is in column 2 then how come you typed column index number as 1 and it gave accurate result?
Watch carefully you will get your answers
Please explain..
@@AbhijeetjiTechnical4M I have watched multiple times that's why I asked the question..
Selected table array me wo 1st column ha
Jaha se table arry start hota h waha se count Kiya jata h to column. table arry ek hi clum select kiye h to ek hi lege
Woow 🥰
Please Tell what is Coloum index number? in Vlookup.
Column index number is position of column that means which column value you want fetch against lookup value
if i want to see that right emp.code is for right employee name ?
Vlookup only fetch data from ur master file when lookup value available in your master file that means your name is right
Amazing
1st coloum m Jo s. N. And emp. Code likha ye coloum up m nhi ja Rhe ye formula batao sir
Mein samjh nahi pa raha telegram per mukhe message karo screenshot lekar I will help there
Sir mere pass 1 data hai jo unarranged hai. Usko kisi format me kaise layenge?
Example
@@AbhijeetjiTechnical4M sir aap apna contact number ya email de sakte hai? Mai aapko excel ka file send karunga.
How can I contact you.. want to clear some doubts
Message me on Instagram
i have two spared sheets one is called stock with price
and another is called calculator
in a stock sheet there is 3 columns category and sub category and price
that shows in calculator sheet in list form
i am not able to get a specific price of category and subcategory wise
ex fruit is category and apple is sub category and 100 is price
in calculator sheet fruit and apple are showing but how can i get the price of it
please help me............
looking to hear from you..
Message me on instagram same id
Use index With match
How to make penetrations percentage in excel
Double candidate ke liye help krdo sir 2 alag alag 0df hai
Example pls
@@AbhijeetjiTechnical4M mere pass 2 alg result pdf hai.. bs ye dekhna hai ki ..ek lista ke candidate dusri me hai ya nhi..
Ek chese btao agr present sheet me mera kuch data match nhi h ot hm vlookup lga rhe h or jo match data nhi h uski jagah NA naa aa k jo available h present sheet me wo aae toh kaise karinge
Use iferror function like this iferror(Vlookup(b2,sheets2!a$2:g$400,2,0),b2
Sir bot achha, koi contact h apka , incase koi confusion ho to
Follow me on Instagram and dm me for any confusion
Brother vlookup to koi bhi try karega iske alawa ar koi formula....
Index With Match u can use
GOOD
Mere paas 10 sheets me alag alag date me data hai, usko hume singke sheet me kisi specified dates me daalna hai, means jo bhi duusri sheet me data ho, new sheet me sirf wahi data aae jis date ka hum chahte hai... Ye kaese ho paega?
For example ; 18 years ka complete daily data hai and humko sirf weekday ka lena hai.. To aese me holiday and Saturday sunday ka data nahi chahye... To ye kaese karege
Using macro and filter you can do it
I need your help.... Mere pass ek master data hai ...... Usmain device name k according two different entries hai .... Only device name comman hai .....mera pass kuch names hai devices k but main chahta hu ek formula lagau ki toh rows mil Jaye mujko device name k according.
Suppose 1000 students ka data hai, usmain se student name comman hai bahut se student ka, assume 100 students hai jinka naam comman hai others 100 students se ..... Name k alava baki sabhi value alag hai jaise enrollment no., Class , age.
Mujko bas name k according data extract karna or duplicate wallo ko bhi lekar aaana hai ager hai vaha toh
Message me on instagram
This will throw error if there is repeating values
If value will be repeat then you have to summarize your data first then apply because all the lookup function give first search result, it wouldn’t go down
Bhai primary data se Sara copy kar lene se ho geya, waha tow sab thik tha data.
Better make pivot table of both sheet an make vlookup
Thank you very much, dear brother. May Allah bless you and open your heart for Hidaya. Please read the Holy Quran.
Vlookup formula not working
Plz tell me
What’s problem
sir kya aap mujhe ye bta jaise ye jo do sheet hai aise meri bhi do sheet hai ..lekin frist sheet pr meri code name or qunty three column h same doosari sheet par hai..lekin frist sheet k anusar doosari sheet pr code name qunty nhi wo uper neeche likhe huye hai. ab dono sheet match kaise karaun same code same. name aaye
2nf sheet per vlookup apply karo
3.00 par ye data apka sheet one par hai toh vo kis row par hai kaise pata kare without Ctrl+f se with formula se kaise pata Karen jab 20k data hai aur usme formula lagate highlight ho gaye
Use VBA code
@@AbhijeetjiTechnical4M full form
sources file link is not working
I think delted
Sir aisa possible hai. If i edit drop down list cell's spelling. So result cell's automatic update spelling..??
Also use conditional formatting then unique or duplicate value, apko pata lag jayega itna zada krne ki zarurat nai hogi
Conditional formatting condition ke base per formatting karta hai Aur lookup formula dusre sheet or workbook se value ko fetch karta hain
And formula always will be automation whenever new data come it will work
Conditional formatting Aur lookup formula mein Jamin aasman ka fark hai
bro jaisa ki ak line me name h Aakash and wo 2-4 line chodkar fir aa rha h and aise hi chal rha h or bich m sare name b ase mix h to kya hume un sabko aksath kr sakte h? jaise Aakash ki jitni row h wo sari ak sath. plz help
Use tocol formula
2nd method
You can use filter formula
Column number 1 kaise liya apne?
Column index number dal kar
How to compare without having any unique values
lots of trick to match your data its totally depend upon your situation
1 se 2 minute toh bilkul bhi n lagra h, koi faster tarika bataye
Dono data ek ke niche ek paste Karo , emp code / name colums pura select karke , Highlight duplicate lagao. Unique values me error hai , EZ gg
another tutorial you should use english so as we can explore every where
Sir mein sheet 1 mein data select kar raha hu but jab mein sheet 2 mein Ara hu tab wo table array nay sheet ka blank Ara hein plz help sir
Download my app from play store and message there
App name -abhijeetji technical 4m
Mere pass do data h pr vo sare upar niche h to agar vo same h to voh highlight ho jaye please bta dijye sir😢😢
First use vlookup to fetch data in front of each row data then use row difference to highlight