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

[@amitranjan5353]

Very knowledgeable video about offset. Thanks a lot.

[@TeachToEach]

Thanks Amit ji

[@sumankumarrai1]

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

[@TeachToEach]

Hey SumanKumar, Thanks itna acha comment likhne ke liye.

[@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

[@realvideos1504]

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

[@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

[@junaidshaikh4880]

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

[@TeachToEach]

My pleasure Brother

[@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

[@RahulKumar-knp]

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

[@TeachToEach]

Thanks Rahul

[@CA_Sushil_G]

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

[@RajeevKumar-ch9sb]

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

[@TeachToEach]

Welcome Rajeev

[@kaleemq99]

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

[@TeachToEach]

Thanks Kaleem Ji

[@Mansijswarnkar]

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

[@TeachToEach]

Hey Thanks Mansij, Feeling great during read you comment.

[@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.

[@greatmanivannan]

Clean explanation ...

[@sanjaynoudiyal9467]

Excellent sir.. Now I have learnt it

[@aamirzain4155]

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

[@TeachToEach]

Bahut Bahut Shukriya Aamir Bhaijaan

[@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.

[@SujathaS-sx3kg]

Thanks for clear and concise explaination Brother.

[@TeachToEach]

Welcome

[@shamshadhassan1709]

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

[@AnkitKumar-ey9mh]

kamaal da vedio agga veer ji, tussi chhaaa gya

[@TeachToEach]

Bahut Bahut Shukriya Ankit Ji

[@smart-office12]

Well explained, thank you🙏

[@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

[@rooul123]

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

[@TeachToEach]

Thanks Rahul for the comment

[@shizosb]

impressed.....👍👍

[@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

[@dillooshariff2452]

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

[@TeachToEach]

Welcome Dillo

[@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.

[@swarajray1995]

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

[@TeachToEach]

Thanks Swaraj Ji

[@ashishrathore5695]

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

[@TeachToEach]

Welcome Ashish Ji

[@Santosh-jx3yf]

Fabulous teaching by you

[@TeachToEach]

Welcome Nandu

[@KiranKumari-ju6lp]

Amazing video sir ❤️

[@gopalamaltare283]

Always direct come to point

[@banadaparasurama32]

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

[@SPUNATIGHOSTWORLD]

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

[@parthopratimdas175]

Thank you sir

[@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

[@YogeshKumar-sc8wh]

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

[@TeachToEach]

Thanks for the comment Yogesh Ji.

[@arifafahmida4045]

1:39 start the video

[@faqirhussainbaba9436]

So Nice. Thanks for this.

[@TeachToEach]

Thanks Hussain Ji

[@azizniazi2454]

Really informative video Special thanks

[@TeachToEach]

Thanks for the video Aziz

[@lakhitolani6830]

Great work boss!!!

[@TeachToEach]

Thanks Lakhi for the comment

[@amzadhussain8310]

Thnks for video..

[@nagappashenoy]

Cool n simple

[@reyansh304]

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

[@manojparashar4703]

Well Explain Boss !!! Thanks

[@TeachToEach]

Thanks Manoj

[@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.

[@SACHINKUMAR-px8kq]

Thankyou so much

[@TeachToEach]

Welcome

[@amitjoshi8997]

वाह सर वाह 👌👌

[@TeachToEach]

Dhanyawad

[@ajaykumar-id2db]

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

[@TeachToEach]

Yes.

[@MahtabAlam-te3je]

wonderful teaching skill

[@TeachToEach]

Welcome Alam Bhai

[@anupamdghosh]

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

[@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

[@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?

[@kirankoli1188]

Nice concept

[@tinkushukla6891]

Gajab bhai ji super

[@TeachToEach]

Welcome Pankaj

[@habibahimu1431]

Thank You SIr

[@kishanpiprotar8185]

good job brother... kip it up 👍

[@TeachToEach]

Thanks Kishan Ji

[@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

[@begnasonline8299]

Nice to much helpful

[@TeachToEach]

Thanks for the comment Begnas.

[@sangitadash3082]

Bohut badhiya

[@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.

[@gaurav1984able]

Achi lagi video.great

[@TeachToEach]

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

[@durgimajhi1629]

nic vedio ,Sir ....

[@Khushi-bk87q]

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

[@rajsahu1029]

Offset formula is very useful, however need some practice

[@nabilaakter6634]

This video is very satisfying

[@TeachToEach]

Welcome Nabila

[@vaibhav_uk]

Skip to 1:40 directly to save your time.

[@narenderyadav1727]

Very nice video

[@TeachToEach]

Thanks

[@sushilbalakrishnan]

Very good.

[@TeachToEach]

Welcome Brother

[@samirparkhi5162]

For motivating me

[@TeachToEach]

Thanks

[@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

[@satyabobby6248]

Super..

[@TeachToEach]

Dhanyawad

[@murtazahgm7854]

very gooooooooooooood thanks bro ..

[@TeachToEach]

Thanks Murtaza

[@mukeshgupta4969]

Superb bhai

[@TeachToEach]

Thanks for the comment Mukesh.

[@naeemarshad1911]

THANKS ALOT- FROM PAKIS TAN

[@aakashshah5733]

Very interesting

[@sanjaybehera9373]

Nice explain sir

[@amatureexplorer]

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

[@SHASHIKUMAR-qm7xl]

This video is very good aboutof excel

[@TeachToEach]

Always Welcome

[@kdstationery344]

Very good

[@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??

[@seemasahota1440]

sir why subtract 3 from counta ............... i really didn't get that.........

[@VikramSingh-kv5vq]

Tell me 1 thing ki 4 column hai mere paas a.b.c.d. isme a .b.C mein value hai d mein nahi hai to print d.. Is it possible kindly reply

[@samirparkhi5162]

Thanks sir

[@TeachToEach]

Welcome

[@ajmalshahtravelling7088]

nice class

[@TeachToEach]

Yes Ajmal Ji

[@1shortv]

Nice video

[@rizahmed716]

great .

[@TeachToEach]

Thanks for the comment Ahmed Ji.

[@thakuranujsingh4419]

Super

[@suryaassociates8653]

Agar coloum A mai 800 se 900 cell ka data hai to hame vahi data multiple coloum mai krna hai to Kaise kre plzz help me

[@TeachToEach]

Jahan tak apko copy paste karna hai pura data select karle uske baad Ctrl + R type kare

[@sudhansusahoo1570]

Please make some dash board video with offset function

[@Kushhmalik]

Thank you

[@TeachToEach]

Welcome Kush

[@shatadalgnguly434]

How we remove duplicate by formula in excel please give this vedio sir

[@TeachToEach]

You can only only highlight , count , or know the duplicate value but cannot remove by formula you should to use delete command for that.

[@shatadalgnguly434]

Please give me the Excel sheet

[@fasialilyas45]

or agar hume first 3 values ka sum lana ho to ?

[@rahulpandey3454]

widh single kaise hai can you explain please in Comment

[@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]

[@TheDextu]

I dont understand the concept of using countA here and the minus here doesn't project the right value. How the heck will the excel get to know the range??!!! Is there other alternative of doing this??

[@pandeyrambabu2095]

how to make shop credit and cash dally report from Excial please please can you make ???

[@TeachToEach]

To make a report on any topic first user must know about the data or fields. Please share which format you are using so that i will make it better Pandey Ji.

[@nrayanthakur786]

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

[@abhishakya5263]

Thanks