Abhijeetji. I am facing one problem. 1. I have one sheet having 18319 entries. 2. Each entry was checked in 13 samples with each sample having 3 replicates 3. I have already calculated the average of the replicates of all the 18319 in 13 samples. 4. Now I want to know that which entry is at least five times higher in a particular sample than its average levels in all the remaining 12 samples (the average I have already calculated). How to do this. I am really worried as I have spent days on it and still unable to solve this. May you share your contact or any other mode of communication? so that I talk to you and share with you my file. thank you.
How can I compare attendance from two workbooks in excel. Which is best and easy to use. In workbook names and id's are mentioned in one column and in another only names are mentioned.Workbook 1 contains both names and IDs (numerical) in one column. Workbook 2 contains only names in one column.
सर मुझे एक्सेल शीट में एंप्लॉय का सैलेरी शीट तैयार किया तो वह मंथ वाइज अलग-अलग सीट में जनरेट ऑटोमेटिक हो जाए उसके लिए कौन सा फार्मूला यूज़ करना कृपया आप मार्गदर्शन कीजिए Sir, I have prepared the salary sheet of the employee in excel sheet, then it should automatically generate month wise in different seats, which formula should I use, please guide me.
Ok then first combined both column (in first aheet) using concatenate formula and also combined both column in 2nd sheet then apply vlookup if srill u r facing problem u can join our Telegram channel and share your data pic there
Sir mere pass gadiya hai unko category wise karna hai.. if formula k sath try Kiya but ye ho nhi Raha hai... Jaise mere ek colum me gadi ka naam jaise Honda Amaze likha hai to hum ye chahate hai ki uske samne wale colum me apne aap wo car likh de.. agar main kisi bike ka naam likhu jaise Hero Spelandor tab uske samne apne aap bike likha aa jaye... Jaise auto likha ho to uske samne three wheeler likha aa jaye... Ab problem ye hai ki ye sab alphabet hai kahi bhi koi numeric value nhi hai... Please solve the problem.
Yes this is possible message me on instagram nahi to tum mere channel per hai aur advance if condition ki video hogi dekh lena kam ho jyga agar nahi hota message me on instagram
@@AbhijeetjiTechnical4M while comparing two sets of data, if the difference is in supplier name, city name, or state, how to find the differences ? What if two columns have differences ?
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](http://i.ytimg.com/vi/gAY9is-ahQY/mqdefault.jpg)
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](/img/tr.png)
Your vlookup formula is very useful... Best video for understanding
Wow! This is just amazing. The way you have explained, it's awesome. Great Work!!
thanks for this informative video and explaining in a very easy way
Pure RUclips pe is video ko dhundhte reh gya aaj mila, mera problem solve ho gya ❤❤❤
Sir aapne achhe se samjhaya hai
very good video
Abhijeetji. I am facing one problem.
1. I have one sheet having 18319 entries.
2. Each entry was checked in 13 samples with each sample having 3 replicates
3. I have already calculated the average of the replicates of all the 18319 in 13 samples.
4. Now I want to know that which entry is at least five times higher in a particular sample than its average levels in all the remaining 12 samples (the average I have already calculated).
How to do this. I am really worried as I have spent days on it and still unable to solve this. May you share your contact or any other mode of communication? so that I talk to you and share with you my file. thank you.
Very helpful sir
Nice Video Thanku Sir
Love you brother
Also make a video on how to compare the two paragraphs and highlight the differences.
your teaching style is really amazing guru ji
Looking video 📸😊
Well explained
Sir thanks your support
12:26 Alt and press equal to for sum
Sur, please help me at 2.40 you said freeze kar denge, but range freeze kaise karna hai sir
F4 press karke
@@AbhijeetjiTechnical4MSir, any other option please, because in my laptop F4 key has a function of brightness
Nice
Please make a video on how to compare and highlight differences of two table datas.
Many time putting vlook up formula brings NA because of some formatting issue... How to resolve those cases??
Download my app and message there through chat
App name - abhijeetji technical 4m
How can I compare attendance from two workbooks in excel. Which is best and easy to use. In workbook names and id's are mentioned in one column and in another only names are mentioned.Workbook 1 contains both names and IDs (numerical) in one column.
Workbook 2 contains only names in one column.
Message me telegram with excel file
सर मुझे एक्सेल शीट में एंप्लॉय का सैलेरी शीट तैयार किया तो वह मंथ वाइज अलग-अलग सीट में जनरेट ऑटोमेटिक हो जाए उसके लिए कौन सा फार्मूला यूज़ करना कृपया आप मार्गदर्शन कीजिए
Sir, I have prepared the salary sheet of the employee in excel sheet, then it should automatically generate month wise in different seats, which formula should I use, please guide me.
Amin ji without see your data I can’t explain
If I want to match 2 columns in one excel sheet with 2 columns in other excel sheets
Ok then first combined both column (in first aheet) using concatenate formula and also combined both column in 2nd sheet then apply vlookup if srill u r facing problem u can join our Telegram channel and share your data pic there
How to reconcile two data in which between the description numbers are mentioned and we need to reconcile same numbers.
Yes you can do it with complex Formula
Excel sheet open but no editable and save option not shown
After open download it
❤️❤️❤️
Sir, how can we compare two excel sheets having various multiple duplicate entries?
First you have to convert both sheet into unique I meant remove duplicates then match
Dear sir practice fil dowanload kaise hoga
Click on download practice file
💚💚💚
App ki vide baar baar doubling hoo ri hay means phir repeat hoo ri hay Jo student ko bohat parayshan ker ri hay. Kindly ais ko settle karayn
I think you have to learn in proper way you are the one person Jise samjhne mein problem aa Rahi so focus on learning
Naam aur Baljeet ko alag alag kaise karenge batane ki kripa Karen
Can u explain
how to freeze the range
Select range and press f4 key from your keyboard
6:00 comparision of amt
value ko absolute ksy kia wo tu btya nh
F4 press karke
Try Kiya par false ka option nhi aa rha hai???
What’s the problem
Unable to understand can u explain kaushik
😊
If only amounts are both side
No there data
Then not possible one common value should be available
Sir mere pass gadiya hai unko category wise karna hai.. if formula k sath try Kiya but ye ho nhi Raha hai... Jaise mere ek colum me gadi ka naam jaise Honda Amaze likha hai to hum ye chahate hai ki uske samne wale colum me apne aap wo car likh de.. agar main kisi bike ka naam likhu jaise Hero Spelandor tab uske samne apne aap bike likha aa jaye... Jaise auto likha ho to uske samne three wheeler likha aa jaye... Ab problem ye hai ki ye sab alphabet hai kahi bhi koi numeric value nhi hai... Please solve the problem.
Yes this is possible message me on instagram nahi to tum mere channel per hai aur advance if condition ki video hogi dekh lena kam ho jyga agar nahi hota message me on instagram
@@AbhijeetjiTechnical4M ok sir waise aapko maine insta par bhi massage kar diya hai.
I m not satisfied, due to if zip code double or triple so I can't handle
Then you have to use index with match function or Xlookup formula
Agar zip code, supplier name, city name, ya state mein kuda gadbad hai toh ? Aur ek hi example mein 2 columns mein problems hai toh ?
Can u explain not able to understand
@@AbhijeetjiTechnical4M while comparing two sets of data, if the difference is in supplier name, city name, or state, how to find the differences ? What if two columns have differences ?
Formula freeze kyo karte hai
Kyonki jab formula ko drag karenge to range automatic change hota Raheja isliye hum use freeze kar dete hain
Two different workbook match ka kuch nahi bataya.
Video available on channel visit my channel
@@AbhijeetjiTechnical4M THANKS
Waah kya logic h, thumbnail h Match data only 2 Minut, aur VIdeo h 17 min ki.😅😂😂😅😅
Video mein explain Karke bataya Gaya hai by the way work sirf 2 minutes ka hai
whts absolute free
your sheet data is not opened in correct ways..
Download app and message there
Good