Offset formula in excel hindi

[@kevaldodia]

Very good effory. You are teaching hard topic in very easyily. I daily watch your channel for guidance. Thank you.

[@TeachToEach]

Uuuhhhhhh..... Really Thanks Keval

[@sumankumarrai1]

Kya guru chha guess.. apka samjhane ka tarika ... Wow best

[@TeachToEach]

Hey SumanKumar, Thanks itna acha comment likhne ke liye.

[@greatmanivannan]

Clean explanation ...

[@RahulKumar-knp]

Nice tutorial.......and nice teaching voice also.....good sir

[@TeachToEach]

Thanks Rahul

[@chinmayeesingh9040]

yr way of explanation is very best because its simple...... otherwise others make it complex by explaing more hazarldly though their videos r good

[@TeachToEach]

Thanks Roebloom, So nice comment from you . I'm Blushing

[@Dev_Bartwal]

Hwy friend..bhut mst tarika.hai padane ka bawa.. Plzzz or b share krte rhna.. i m big fan of ur Big bro

[@TeachToEach]

Oho Feel Good received a message from Uttrakhandi Boy ... Thanks

[@Dev_Bartwal]

Yeah bro... ap b uK se ho kya :p

[@TeachToEach]

Bhai aapne sirf channel ka naam hi dhekha ... Mera naam hai Ashish Rawat ab ye to pata hi hoga ki rawat bhi Uttrakhand ke garhwali hote hai

[@Dev_Bartwal]

TeachToEach bhai ji yaar me video me magan ho gya tha ap ki.. Dusri video dekhi ap ki reverse vlokup us me pata chala naam aap ka... Gr8 bhai Uk me b excel guru hai...

[@TeachToEach]

Yup kyu nahi

[@realvideos1504]

Difficult formula explained in an understandable way....good job

[@CA_Sushil_G]

Good that your video are able to watch in smartphone screen.

[@amitranjan5353]

Very knowledgeable video about offset. Thanks a lot.

[@TeachToEach]

Thanks Amit ji

[@parthopratimdas175]

Thank you sir

[@gopalamaltare283]

Always direct come to point

[@RajeevKumar-ch9sb]

Really very useful video and Thanks a lot for this video.

[@TeachToEach]

Welcome Rajeev

[@junaidshaikh4880]

Excellent brother, very nice video. Today I learned a lot with you. Thanks for it.

[@TeachToEach]

My pleasure Brother

[@SACHINKUMAR-px8kq]

Thankyou so much

[@TeachToEach]

Welcome

[@AnkitKumar-ey9mh]

kamaal da vedio agga veer ji, tussi chhaaa gya

[@TeachToEach]

Bahut Bahut Shukriya Ankit Ji

[@shizosb]

impressed.....👍👍

[@rimpalkaur4699]

This is wonderful information sir and thank you so much because it is very helpful video sir thanks again 👍👍😊😊

[@TeachToEach]

Thanks for the comment

[@rimpalkaur4699]

Sir, bodmas, template ka kya use ha excel me and how it works, please answer me

[@aamirzain4155]

Very very nice Sir ji..... aap ke samjhane ka tarika bahot achcha hai..... Thank you very much...

[@TeachToEach]

Bahut Bahut Shukriya Aamir Bhaijaan

[@sanjaynoudiyal9467]

Excellent sir.. Now I have learnt it

[@SujathaS-sx3kg]

Thanks for clear and concise explaination Brother.

[@TeachToEach]

Welcome

[@alpeshdoshi7827]

hi....sir....nice video... way u teach with simple explanation and example is too good....I like it very much.... waiting for more use full lesson

[@TeachToEach]

Thans Alpesh , definitely shall upload some interesting videos.

[@amzadhussain8310]

Thnks for video..

[@kaleemq99]

Very much appreciate it. Wish I could thank you more for your effort.

[@TeachToEach]

Thanks Kaleem Ji

[@rooul123]

Clear voice with good content explanation.....................

[@TeachToEach]

Thanks Rahul for the comment

[@KiranKumari-ju6lp]

Amazing video sir ❤️

[@kishanpiprotar8185]

nice bri this formula is a really usefull in case of last 7 days and mothly MTD reports

[@kishanpiprotar8185]

nice bro this formula is very useful to creat dashboard of last 7 days competitive reports

[@TeachToEach]

Kishan Ji .... Thank you so much for this comment

[@tinkushukla6891]

Gajab bhai ji super

[@TeachToEach]

Welcome Pankaj

[@krmotionexcel]

Sir useful video..............he...... Sir muje ek question he.... Dekho " me 1sheet Bana Na chata hu jisme 1 sheet me full details fill keru ,jeseke -product/qty/Wight/netprice .....sub kuch. 2nd sheet me kuch product likhu to bakiki use releted sari details automatic fill ho jaye... "Is Ko hum store me use ker sekte he " Can you make this video on topic...... I'm still waiting for your video.....

[@TeachToEach]

Thanks question puchne ke liye ,,,, Dheko Tech bhai apko iske liye ek chota sa VLOOKUP formula lagana hoga kaise lagana hai maine apni video me bata rakha hai . Agar apko sheet chaie to aap apni sheet mujhe de dejiye main apko formula se answer dalke de dunga jisse apko aasani hogi shikne me.

[@mansijswarnkar4389]

GOOD ONE, YOU JUST MADE IT SO EASY - THANKS !!

[@TeachToEach]

Hey Thanks Mansij, Feeling great during read you comment.

[@banadaparasurama32]

Plz make one video using offset with floor formula related to gst

[@savitarawat7159]

Nice video

[@sizzlersizzle8921]

Fabulous video. Thanks. One thing... Video time 8.00 mei.. Aap me bola 40+48=98, it is 88. Not 98. Rest..excellent.. Thanks

[@shamshadhassan1709]

This is the easiest way you taught us. Thanks lots of tonn for the video

[@guruprasadp6670]

Thank you very much for making effort understanding offset in easy way and simple. hats off please upload more videos:-)

[@TeachToEach]

Thanks for such an appreciating comment Gurupasad P.

[@habibahimu1431]

Thank You SIr

[@dillooshariff2452]

Hello Greetings from Maurituis Thanks for this video. Very nicely anc clearly explained.

[@TeachToEach]

Welcome Dillo

[@vaishnavibuyan3155]

awesome .... great work sir

[@TeachToEach]

Welcome Vaishnavi, I am not a sir You can call my name "Ashish" or "Ash" my nick name which i like most

[@Santosh-jx3yf]

Fabulous teaching by you

[@TeachToEach]

Welcome Nandu

[@smart-office12]

Well explained, thank you🙏

[@kirankoli1188]

Nice concept

[@amitjoshi8997]

वाह सर वाह 👌👌

[@TeachToEach]

Dhanyawad

[@vtchauhan1]

Sir.. video ke liye thanks and motivate Karne ke liye bohot bohot bohot danyawad

[@TeachToEach]

Real motivation Chauhan Sahab aap agli video me dhekhna or comment bhi karna. Aapka sath chaiye bus.

[@ashishrathore5695]

very good you are doing great work. thanks for this........ excel tips

[@TeachToEach]

Welcome Ashish Ji

[@swarajray6997]

Nice work thank you so much for your efforts,👍👍

[@TeachToEach]

Thanks Swaraj Ji

[@YogeshKumar-sc8wh]

I like this vedio and your comunication ......

[@TeachToEach]

Thanks for the comment Yogesh Ji.

[@faqirhussainbaba9436]

So Nice. Thanks for this.

[@TeachToEach]

Thanks Hussain Ji

[@begnasonline8299]

Nice to much helpful

[@TeachToEach]

Thanks for the comment Begnas.

[@sushilbalakrishnan]

Very good.

[@TeachToEach]

Welcome Brother

[@anupamdghosh]

Great Font. Which is this font. Thank you in Advance.

[@azizniazi2454]

Really informative video Special thanks

[@TeachToEach]

Thanks for the video Aziz

[@satyabobby6248]

Super..

[@TeachToEach]

Dhanyawad

[@narenderyadav1727]

Very nice video

[@TeachToEach]

Thanks

[@aakashshah5733]

Very interesting

[@lakhitolani6830]

Great work boss!!!

[@TeachToEach]

Thanks Lakhi for the comment

[@reyansh304]

Sir please reply Sir abhi aap kon sa job karte ho Please give me a career Guidance 🙏

[@SPUNATICHANEL]

Dear jinko sikhana hai woh sikhate hai duniya bhaut badi hi dear chado yeh sab THANKS FOR YOUR OFFSET FOORMULA................................EVEN YOU DONT KNOW EVERY THING THEN SIMPLE QUESTION DO U HAVE SEEN GOD OF ALMIGHTY NO NA IT DOES NOT MEANS GOD IS NOT THERE SO ITS ALL ABOUT OTHER EACH AND EVERY INDIVIDUAL HAVE DIFFERENT CHARACTER BRO.............................ALL FINGERS WERE NEVER THE SAME IS IN TID

[@arifafahmida4045]

1:39 start the video

[@manojparashar4703]

Well Explain Boss !!! Thanks

[@TeachToEach]

Thanks Manoj

[@rajsahu1029]

Offset formula is very useful, however need some practice

[@nagappashenoy]

Cool n simple

[@naeemarshad1911]

THANKS ALOT- FROM PAKIS TAN

[@kdstationery344]

Very good

[@sanjaybehera9373]

Nice explain sir

[@MahtabAlam-te3je]

wonderful teaching skill

[@TeachToEach]

Welcome Alam Bhai

[@durgimajhi1629]

nic vedio ,Sir ....

[@sangitadash3082]

Bohut badhiya

[@gaurav1984able]

Achi lagi video.great

[@TeachToEach]

Aap logo ko achi lag rahi hai video isse jada mujhe kuch nhi chaiye...Anyways thanks Gaurav

[@thakuranujsingh4419]

Super

[@simfinso858]

Nice

[@TheDextu]

I found an easier alternative to do this without using countA, we need to project the row number and column number where the starting point of intersection needs to be, then expand to the last limit. Anyway, indeed it was a nice video.

[@TeachToEach]

Its good to hear that you have a another way to solve the same query . Keep it up Abhijit.

[@amatureexplorer]

Sir I want to make bold and underlined some part of the sentence using concatenate formula in MS Excel. What should I do?

[@Kushhmalik]

Thank you

[@TeachToEach]

Welcome Kush

[@AdityaJhaAdi]

Very helpful video please share some vba video also. Thank you sir

[@TeachToEach]

Thanks Aditya , I m planning to make videos on VBA but It takes time.

[@raazchannel351]

Aditya Jha thanks

[@mmmoogi]

Very nice can I see ur all videos share ur website

[@TeachToEach]

Moggi Ji Thanks for comment but currently i have not any website

[@mukeshgupta4969]

Superb bhai

[@TeachToEach]

Thanks for the comment Mukesh.

[@abhishakya5263]

Thanks

[@samirparkhi5162]

For motivating me

[@TeachToEach]

Thanks

[@nabilaakter6634]

This video is very satisfying

[@TeachToEach]

Welcome Nabila

[@ajmalshahtravelling7088]

nice class

[@TeachToEach]

Yes Ajmal Ji

[@ajaykumar-id2db]

Hi this very nice to learning with your online tutorial. Do you have excel workbook for this offset function.

[@TeachToEach]

Yes.

[@samirparkhi5162]

Thanks sir

[@TeachToEach]

Welcome

[@murtazahgm7854]

very gooooooooooooood thanks bro ..

[@TeachToEach]

Thanks Murtaza

[@kishanpiprotar8185]

good job brother... kip it up 👍

[@TeachToEach]

Thanks Kishan Ji

[@rizahmed716]

great .

[@TeachToEach]

Thanks for the comment Ahmed Ji.

[@jetenderkhatri1957]

First of all, thank you for this useful video. I have a question, what makes this offset function different from other functions? E.g, to make sum or avg of last 3 rows/columns, we could use if function as well and this will also work as we will update the data. Then what makes it different??

[@dynamic_duo157]

Superb explanation sir Plzz make a video regarding below output based on dropdown list Desired output: If dropdown shows "November 2019" Jan19 Feb19 Mar19 Apr19 May19 Jun19 Jul19 Aug19 Sep19 Oct19 Nov19 Nov19 Dec19 Jan20 . . As per drop down only "selected month and year should change" remaining months and years should be as usual .

[@khushihandle567]

Please Suggest how can we use offset to make the range dynamic? Please reply

[@venajahirhussain9672]

Good

[@SHASHIKUMAR-qm7xl]

This video is very good aboutof excel

[@TeachToEach]

Always Welcome

[@sudhansusahoo1570]

Please make some dash board video with offset function

[@shwetasharma5128]

sir ek confusion h..counta me SE Jo 3 minus kar rhe h..wo uper wale b to ho sakte hai...humne last wale to kuch fix kiye nahi h..Na hi last wala koi formula lgaya

[@RightToSalute]

Bahut acchi lagi mere bhai teacher ho kya ?

[@TeachToEach]

Nahi bhai Teacher nahi aapki tarah employee hi hu.

[@vaibhav_uk]

Skip to 1:40 directly to save your time.

[@babarqureshi5043]

Kindly make the video cell hyperlink

[@amatureexplorer]

Sir I want to make bold and underlined some part of the sentence using concatenate formula in MS Excel. What should I do?

[@mmmoogi]

but I want to see ur all videos Sir

[@TeachToEach]

Moogi ji i deleted every video after downloaded. So only way to watch my video is "KZbin"

[@arunsharmaarts67]

sir mast video h

[@TeachToEach]

Arun bhai sir mat bolo yahan apka dost hai koi sir nahi. Thanks for comment

[@24---]

owsome ....

[@TeachToEach]

Thanks Jalendhar Ji

[@Exceltrick4u]

agar hum wed ke column mein last 3 row mein 2nd last blank rkthe hai to ye upar ka 3 add krega jo galat hai.. please make a video of it.

[@nrayanthakur786]

36 vala result to index se b aa skta h.. M i ryt or not?

[@induverma9021]

In sum, If I m deleting number class A,B Then it is not working properly. I m getting and 0 while 2 numbers are of class C,D there. Why is it happening. Help me Ashish..

[@TeachToEach]

Share your excel sheet on [e-mail]