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 ❤😊

Last wording is very useful in life

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 ❤

Great Video Sir thanks

Great video sir

Thank you sir. Amazing info.

Namaste sir,aap ne toh power query ka series Lana hi band kar diya

Very Nice !

Helpful video sir 😍

Value added content 🎉😊sir ✌️💯

LOVE U SIR

Bhot acha smjahaya thank u

Nice sir❤❤❤

Hi, Nice video. Regards. Shakeel Ahmad Karachi, Pakistan.

Sir excel me sheet and sheets formula window 2010 me kaam karega

😍❤❤❤

Hello sir thanks for made your channel today I got a job on mis executive by your videos as a fresher.😀😀

@Innozant

6 ай бұрын

Congratulations..have a wonderful career ahead.

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)

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

Sir power bi ki playlist ko continue krdo

Sir, for trick number 1 sumproduct can also be used in place of Sumif

Question 3 =sum(Filter(array,productrange="nokia",""))

Sir i have question if I have to find Out "DATE OF BIRTH" FROM AGE GIVEN , HOW COULD I DO THAT? PLEASE HELP

Sir please Power Query, Power Pi Board and power Bi ka video banayaaa....

Nice Video Sir Sir Kya Excel Ki Ek Hi Sheet Me 2 ya Jyada Tables Banaye Ja Sakte Hain?

@Lofemusic471

6 ай бұрын

Ha Bhai bana sakte hai

Plz upload power bi course in easy way

Sir please make series on SQL

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.

Sir SQL ki series bhi padhao please

Please make auto-update Google sheets from Google finance for India stocks

Hello Sir.. Which software you use to record your screen? The screen recording quality is too good. Please reply...

Killer sir I need mi and ai series pl

Sir ek hi cell mei 2 ya 3 date ko formula se kese laye. Jese 26,27&28 Jan 2024

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

Paji, Can u please Show Method, How to covert Total VALUE/ AMOUNT in words automatically

@Innozant

5 ай бұрын

Kindly watch spellnumber video

I'm trying first trick but not working correctly ? Why?

Sir we need power BI videos

@Innozant

5 ай бұрын

Visit innozant website

@sanjugalande

5 ай бұрын

Waha to hai par u tube par nahi aarahe latest

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.

@Innozant

6 ай бұрын

Its not a wrong function ,Its understood that in case of lookup fubction your data must be sorted ij ascending order

You are the Master of Excel.🫡