Excel OFFSET + MATCH Function | How to use Offset Match Formula in Excel

[@JatinKumar-yc1ij]

sir your way of explanation and teaching is really interesting and interactive. i really appreciate your hard work. you are a great teacher. every computer institute should have a teacher like you.

[@Innozant]

Thanks Jatin Ji..God Bless You.Happy Learning dear❤️

[@savanthk]

So clear and easy to follow, loved it. Thank you

[@Innozant]

Thanks .keep learning

[@happyhotify]

Thank you so much Sir, because of you I was able to change my profile to Data Analyst

[@rajendrashriwas9254]

offset bahot kamal ka function hai sir, aaj ek badi lag rahi samasya ko aapke is video ki sahayta se pal bhar me suljha diya Thankyou very much

[@Innozant]

Keep learning

[@ankitmehra3074]

Thankyou sir we appreciate your valuable knowledge lots of love 👏👏👏👏

[@RahulChauhan-ll9pu]

Hats of guru ji 👍🙏

[@Innozant]

Thanks Rahul Ji👍❤️

[@yashpatil3375]

Very nice 👍

[@adnanshoukat807]

sachi sir g aj match k sath samjh ayi aj mny 3 pending offset queries solve kr hi ln after watching this video. thnx sir g...

[@Innozant]

Are wah..Haan ap tense ho rakhe the ki Nahi aa Raha hai samajh ..now happy you are 👍♥️🙏

[@pramodbhavsar4488]

Very excellent offset and match function example practical explain by very nicely thank you sir I await

[@Innozant]

Thanks Pramod Ji.. Happy Learning 🙏♥️

[@awanishanurag1763]

Great manoeuvre by you with Excel Formulas !!

[@Innozant]

Thanks Awanish

[@Jitenderkumar-yp1rn]

Excellent sir jii... really this is the advance level formula... Thanks for this valuable video...😍😍❤❤

[@Innozant]

Thanks Jitender... Happy learning..Good Night ❤️👍🙏

[@arunendravishwakarma6698]

Excellent Sir, I like the way you teach.

[@Innozant]

Thanks Arunendra❤❤🙏🙏

[@rinturoy8014]

The offset function is the best alternative to Index

[@situsahoo2482]

Hoye hoye.ab aayega majja offset.using in office 🔥🔥🙏🙏

[@Innozant]

Haha..happy learning..good night ❤️👍🙏

[@meditationmusic6482]

So nice Sir ji

[@Innozant]

Thanks Sanoj ji

[@ek_nazaria]

Thank u so much sir

[@Innozant]

Thanks Priya ❤️

[@binaykumarnayak9114]

Thank you Sir.. God bless you

[@Innozant]

Thanks Binay Ji❤🙏

[@satishojha6240]

Again very useful video thanku sir.

[@Innozant]

Thanks Satish Ji🙏🙏❤️

[@KuldeepSingh-nq1vi]

Very Useful Video Sir.

[@Innozant]

Thanks dear

[@tejpalsain1507]

Very nice sir jee. Thanks for it.

[@Innozant]

Thanks Tejpal🙏♥️

[@PavanKumar-cm2sz]

gr8 formula😎

[@Innozant]

Thanks Pavan Ji.Good Night.❤️👍

[@gauravbhatia7987]

Thnq sir so much

[@Innozant]

Thanks Gaurav Ji.. Good Night

[@pramodkumar-ke8gd]

Lajawab Sir

[@Innozant]

Thanks Pramod Ji..❤❤

[@rajibdebnath6778]

Many more thnx

[@Innozant]

Thanks Rajib ji

[@kinghundred]

very superb sir

[@ramanmangat3320]

Nic one sirr

[@Innozant]

Thanks Raman Ji❤️🙏

[@pramodbhatt6906]

Sir, In Your First Example how we can sum Jan to Apr in each Row in Column H tried the same but getting output in 1st row only (tried Row() instead of given Row No. Pl help....

[@prakashchaudhari8444]

Concept made very clear. Your way of explaining is very simple and clear. Can I get the files for practice.

[@Innozant]

Dear Prakash ,Kidnly find the practice file link in video description.. assignment master folde link is there

[@mahaboobhossain5076]

Excellent

[@Innozant]

Thanks Mahaboob👍🙏❤️

[@mahaboobhossain5076]

I need a video of index match with choose function plzzz brother

[@Innozant]

Ok..no issue

[@pramodbhatt6906]

Nice

[@Innozant]

Thanks Pramod ji

[@puransingh-sx2tk]

Ab main bol sakta Hu mere ko advance excel aata hai or Dili ab dur nahi hai 👌🏻🙃😊 pura shareh aap ko

[@Innozant]

Offcourse Puran..🙏❤️👍

[@horrorlovestories]

Sir 7:21 mein 0 column kyu add karte hain jabki reference sales pe hai. Aur offset ka count reference se karna hai ki uske neeche se?

[@tausifanwar7185]

Great Sir ji, But can you make it more dynamic ( add up values that meet criteria) Product -Moto Start year -2012 Through to -2014 Total sale of Moto from 2012 to 2014 ? and when we change the year (Start year or Through to ) then output should also get changed..Can you please help into this .

[@Innozant]

ok Tausif ..Will di it in another way..

[@saadkhan13]

I have one Exel question can you help me out?

[@jayantabhattacharyya628]

Dear Sir Again excellent tutorial Sir Ji. And very innovative too. Sir, can I use this offset function with both index and match function? If possible, give some examples in your next tutorial. Thanks Jayanta Bhattacharyya.

[@Innozant]

Sur Jayanta Ji..no. of videos of offset still pending dear... Happy Learning ♥️🙏

[@moodyman8239]

Please answer give anybody Difference among Match index, offset

[@sayeedshaik573]

🥰 Sumif and if be like :- 😂 are you challenging me #Offset

[@Innozant]

Haha..very true❤️🙏

[@sayeedshaik573]

@@Innozant sir please zayada sa zayada video upload kijiye sir, daily waiting for videos ....

[@sayeedshaik573]

@@Innozant or sir ji.. aap ka plus course ha kya excel ka

[@poojamishra9721]

I have one question, We have a table first row is let's say months name and first column is let's say products. Shuru ke kuch months mei 0 hai fir aagey ki kuch months mei values hai Ye har row ke same months mei 0 hona fixed nhi hai kisi product ke initial 2 months mei 0 hai kisi product ke initial 5 months mei 0 hai Hume agar standard deviation nikalna ho toh offset ke saath match ke liye lookup_value kya lenge?

[@Innozant]

Kindly share your query with explanation @innozantofficial telegram id

[@NehaSharma-zn8dt]

Sir what is difference between Index and Offset. Why we use Offset why not Index. However Index also doing same thing. Confusion

[@Innozant]

Neha ji . Perspective of Offset is different, It is use to create dynamic range ..kindly watch both of the videos first,You may able to feel the difference ❤️

[@jsedit.]

❤

[@nkememes1637]

Example file is not exist at given link

[@Innozant]

It is available in assignment master direct link given to all play list example

[@ankitmehra3074]

Sir if i want this name in proper manner like A N K I T . It is in one cell how will i remove the space from it. I want my name like this ANKIT. How we can do it??

[@tjr1421]

Trim function?

[@ExcelGuru]

Brother waiting for pro quest 3 solutions video and pro quest 4

[@Innozant]

Every alternate Sunday dear .🙏❤️

[@chandandasy2k10]

sir in a range same name exists twice.how to sum their value by offset function.

[@Innozant]

First make it unique by using countif then apply formula

[@chandandasy2k10]

Sir in the range total name is 7.within this range 2 name are duplicate.when I do unique count it will 5.after that when apply offset function with sum then sum only 5 records out of 7.i want whose name i select their value will be add or sum.how it would be possible.

[@nishachauhan9103]

Sir 5:43 में आपने height खाली छोड़ा है उसमें एक लिख सकते थे ! एक row की तो उसे जरूरत है

[@Innozant]

Aur nhi likhe usme aur likhte to kya fark aata ?🙂😀

[@pramodbhatt6906]

Can we use offset function with sumifs, countifs etc....??

[@Innozant]

Offcourse..why not

[@pramodbhatt6906]

@@Innozant Any Video offset with sumifs

[@aaqibchaudhary786]

SIR AAP SEPRATE LINK JO DAALTE HO WO OPEN NAHI HOTA KISI KA BHI, HAR VIDIO KA

[@Innozant]

Link broken ho gya hai use dubara main activate kar ra hu..aap recent video ke check kren link wo kaam kar ra hoga..bht jald direct download link sahi kar ra hu🙏