Q no. 3 ❤=COUNTA(OFFSET(A1, MATCH(H1,A2:A11,0),1,1,4)) ❤=VLOOKUP(H1,TABLE,COUNTA(OFFSET(A1, MATCH(H1,A2:A11,0),1,1,4))+1, 0) THANK U SIR, ye sara logic laga pa raha hu because of you ❤😊
Q no. 5 (my attempt) =sum(offset(a1, match(f3, a2:a9, 0) 1,1,3)) We can extract the same output with help of index function as well.. Thnk u my dear sir ❤
Hello I have a 1 question I don't understand question is emp. Name - ronnie kumar Require data without kumar Substitute function is not working please help
good efforts to teach and helping us through journey. but brother kia ap batasakte hain ek vba k through hum list ke mutabiq sheets with same format copy karsakte hain. matlab ek form hai jis main humain ek khas jagah par wo value paste karni hai aur jahan list khatam wahan same sheets with form and format bhi khatm.
we can use the given below formulas to find the total number of payment methods and the last payment method for that particular payment id- =COUNTA(OFFSET(A1,MATCH(H1,A2:A11,0),):OFFSET(OFFSET(A1,MATCH(H1,A2:A11,0),),,4)) =INDEX(OFFSET(A1,MATCH(H1,A2:A11,0),):OFFSET(OFFSET(A1,MATCH(H1,A2:A11,0),),,4),,H2)
Sir I Have One Question sir agar mere pass values hai ek cell mai like 23+90+678+9076 toh mujhe iska sum chahiye textsplit se toh ho raha hai but iske alawa aur koi formula hai toh So please reply the answer sir
Q no. 3
❤=COUNTA(OFFSET(A1, MATCH(H1,A2:A11,0),1,1,4))
❤=VLOOKUP(H1,TABLE,COUNTA(OFFSET(A1, MATCH(H1,A2:A11,0),1,1,4))+1, 0)
THANK U SIR, ye sara logic laga pa raha hu because of you ❤😊
Q no. 5 (my attempt)
=sum(offset(a1, match(f3, a2:a9, 0) 1,1,3))
We can extract the same output with help of index function as well..
Thnk u my dear sir ❤
लास्ट डायलॉगस आर व्हेरी इंप्रेषिव सर जी 👍
Thanks.keep growing
Great Video Sir thanks
Namaste sir,aap ne toh power query ka series Lana hi band kar diya
Great video sir
Nice Video Sir
Sir Kya Excel Ki Ek Hi Sheet Me 2 ya Jyada Tables Banaye Ja Sakte Hain?
Ha Bhai bana sakte hai
Sir excel me sheet and sheets formula window 2010 me kaam karega
Last wording is very useful in life
Hello I have a 1 question I don't understand question is emp. Name - ronnie kumar
Require data without kumar
Substitute function is not working please help
Very Nice !
good efforts to teach and helping us through journey. but brother kia ap batasakte hain ek vba k through hum list ke mutabiq sheets with same format copy karsakte hain. matlab ek form hai jis main humain ek khas jagah par wo value paste karni hai aur jahan list khatam wahan same sheets with form and format bhi khatm.
Thank you sir. Amazing info.
Hello sir thanks for made your channel today I got a job on mis executive by your videos as a fresher.😀😀
Congratulations..have a wonderful career ahead.
Bhot acha smjahaya thank u
Value added content 🎉😊sir ✌️💯
Hi,
Nice video.
Regards.
Shakeel Ahmad
Karachi, Pakistan.
Helpful video sir 😍
Sir please Power Query, Power Pi Board and power Bi ka video banayaaa....
Sir, for trick number 1 sumproduct can also be used in place of Sumif
Sir i have question if I have to find Out "DATE OF BIRTH" FROM AGE GIVEN , HOW COULD I DO THAT? PLEASE HELP
we can use the given below formulas to find the total number of payment methods and the last payment method for that particular payment id- =COUNTA(OFFSET(A1,MATCH(H1,A2:A11,0),):OFFSET(OFFSET(A1,MATCH(H1,A2:A11,0),),,4))
=INDEX(OFFSET(A1,MATCH(H1,A2:A11,0),):OFFSET(OFFSET(A1,MATCH(H1,A2:A11,0),),,4),,H2)
Plz upload power bi course in easy way
LOVE U SIR
Sir power bi ki playlist ko continue krdo
Sir please make series on SQL
Hello Sir.. Which software you use to record your screen? The screen recording quality is too good. Please reply...
Nice sir❤❤❤
Sir SQL ki series bhi padhao please
You are the Master of Excel.🫡
Question 3
=sum(Filter(array,productrange="nokia",""))
Please make auto-update Google sheets from Google finance for India stocks
Sir I Have One Question sir agar mere pass values hai ek cell mai like 23+90+678+9076 toh mujhe iska sum chahiye textsplit se toh ho raha hai but iske alawa aur koi formula hai toh So please reply the answer sir
😍❤❤❤
Sir ek hi cell mei 2 ya 3 date ko formula se kese laye. Jese 26,27&28 Jan 2024
Paji, Can u please Show Method, How to covert Total VALUE/ AMOUNT in words automatically
Kindly watch spellnumber video
Killer sir I need mi and ai series pl
Sir we need power BI videos
Visit innozant website
Waha to hai par u tube par nahi aarahe latest
I'm trying first trick but not working correctly ? Why?
Sorry Sir,
Trick No. 05 wrong function
Because in case of lookup function the very first column has to sorted but in this case our data hasn't sorted.
Its not a wrong function ,Its understood that in case of lookup fubction your data must be sorted ij ascending order