Get Free Notification for Upcoming Videos = forms.gle/kXmk3Tp5SKhuhC5Q9 Join our telegram group to get Practice file : t.me/learnmoreindia/1731 V-lookup Playlist: ua-cam.com/play/PLLD1o3p3r3-1OZ5--Aht1kH8ut1l9Bb29.html Attend Satish sir's Online Webinar Free: courses.skillcourse.in/webinars/
Sir 2 sheet hai, 1 hai sales sheet month of October 24 and 2nd sheet me 12 GST number hai to vo 12 number muje 1st sheet me search krne hai, vo 12 GST number ko October 24 me kitni bar sales Kiya hai ye dekhna hai to konsa formula apply krreee
1. Sales sheet (October 24): Yahan par aapka data hoga jisme GST numbers ka column hoga. Maan lijiye GST numbers Column A mein hain. 2. GST numbers sheet: Yahan par aapke paas 12 GST numbers hain (maan lijiye yeh numbers Column A mein hain). Agar aap GST number sheet ke first GST number ko October sales sheet mein dhoondhna chahte hain, to aap COUNTIF formula ka use kar sakte hain. 1. Sales sheet (October) mein ek naya column (maan lijiye Column B) add karen. 2. Ab B2 cell mein yeh formula apply karen (agar aapka first GST number GST numbers sheet mein A2 cell mein hai): =COUNTIF('October Sales Sheet'!A:A, 'GST Numbers Sheet'!A2)
Table range galat select Kiya hai understand, kyon ki aapne jhan par minimum ka formula lagya hai wahin se hi select karna he table range ko aur aage name tam select karna he aai baat samajh me thodi se video ke liye 4 ghante ka video bana diya
Get Free Notification for Upcoming Videos = forms.gle/kXmk3Tp5SKhuhC5Q9
Join our telegram group to get Practice file : t.me/learnmoreindia/1731
V-lookup Playlist: ua-cam.com/play/PLLD1o3p3r3-1OZ5--Aht1kH8ut1l9Bb29.html
Attend Satish sir's Online Webinar Free: courses.skillcourse.in/webinars/
Thanks sir
Thank you so much 😀
Very useful video sir.
It's my pleasure 😉😉😉😉😉😉
Column 4
❤
Thank you so much 😀
Sir please make video on vlookup+choose+match
Sir 2 sheet hai, 1 hai sales sheet month of October 24 and 2nd sheet me 12 GST number hai to vo 12 number muje 1st sheet me search krne hai, vo 12 GST number ko October 24 me kitni bar sales Kiya hai ye dekhna hai to konsa formula apply krreee
1. Sales sheet (October 24): Yahan par aapka data hoga jisme GST numbers ka column hoga. Maan lijiye GST numbers Column A mein hain.
2. GST numbers sheet: Yahan par aapke paas 12 GST numbers hain (maan lijiye yeh numbers Column A mein hain).
Agar aap GST number sheet ke first GST number ko October sales sheet mein dhoondhna chahte hain, to aap COUNTIF formula ka use kar sakte hain.
1. Sales sheet (October) mein ek naya column (maan lijiye Column B) add karen.
2. Ab B2 cell mein yeh formula apply karen (agar aapka first GST number GST numbers sheet mein A2 cell mein hai):
=COUNTIF('October Sales Sheet'!A:A, 'GST Numbers Sheet'!A2)
Dynamic Horizontal vlookup ka answer sahi nahi aa raha hai sir me bahut pareshan hu
Please watch the video carefully, and you will understand the steps. 😊
3
4
एक्सेल मध्ये A कॉलम मधे असलेला डेटाप्रमाने , B कॉलम मधे असलेला तोच डेटा पण रो वर खाली असलेला डेटा A कॉलम प्रमाणे कसा जुळवावा ?
Column index 4hoga
Sir ek help chahiye
If we use xlookup instead of vlookup, will the problem still exist.
Table range galat select Kiya hai understand, kyon ki aapne jhan par minimum ka formula lagya hai wahin se hi select karna he table range ko aur aage name tam select karna he aai baat samajh me thodi se video ke liye 4 ghante ka video bana diya
Asif sir aap toh kehte ho ki main aap ke comment padta hu toh aap answer ka jawab kyu nahi de rahe ho
Column index wrong
Column wrong ❌
Asif sir aap se baat na chahata hu please apna number send kar do sir
Very useful video ❤
It's my pleasure 🤩🤩🤩🤩🤩🤩🤩
❤