Offset Dynamic Reference | Extract Data with Offset and Index Function in Excel

Offset Dynamic Reference | Extract Data with Offset and Index Function in Excel
Excel Lookup Function Playlist Link- • Excel Lookup Functions...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Music: www.bensound.com
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.c...
✅ Mastering Power BI Video Course
www.innozant.c...
✅ Mastering VBA Video Course
www.innozant.c...
✅ Mastering SQL Video Course
www.innozant.c...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozanti...
#offsetdynamic #offsetdynamicreference#Innozant #misinterviewquestions#msexcel

[@wahidrashid4865]

Sir ap yaqeen karain k jo bi baat ya question mind main aata Hai ap wo sab batain smajha daity hain. Sir Kiya khubsorat treeqy sy smajhaty hain. Great sir. I am proud of you Sir

[@Innozant]

Thanks Wahid sahab.. Really means a lot to me

[@harindersingh-sc2wb]

your motivation on realistic topics charge us to move further with better confidence

[@Innozant]

Thanks dear..Keep Learning

[@tejpalsain1507]

Great sir. Offset कमाल का हैं। पर आपने इसे स्टेप बाय स्टेप समजाया इसलिए यह कमाल लगा और इसके उपयोग भी अब समझ आ रहे है। Thanksge

[@Innozant]

Thanks Tejpal ♥️🙏 Have a wonderful day ahead ♥️

[@atulshukal4072]

बहोत बहोत बढीया वर्क नया देकर खुशी पाता हे धन्यवाद साहेब

[@Innozant]

Thanks Atul Ji.. Happy Learning

[@sanuabhishukla2963]

Alag hi level he aapka Samjhane ka tarika bhi behtreen hai I love that

[@Innozant]

Thanks Shukla Ji❤️❤️

[@anuragsharma2668]

Amezing nice

[@satishojha6240]

Bilkul sahi kaha sir aapne jab question mai fase gaye tabhi pata chaley ga kaun sa function use kare thanku for awesome video sir we always support u. 🙏🙏🙏

[@Innozant]

Thanks Satish Ji...Haan fasna jaruri hai dimag chalne ke liye .Good night ❤️

[@whitedove6878]

You are a genius you are superb. Your teaching is excellent slowly step by step

[@Innozant]

Thanks dear..Keep Learning

[@rohitsisodiya3306]

Awesome sir. Keep it up 👍

[@muhammadsaqlain5162]

sir apki jitni tareef ki jaye kum hai

[@Innozant]

Thanks Dear ❤️

[@adarshgupta6012]

extraordinary teaching skill + superb knowledge. = Innozant KZbin channel 🙏 Perfect combination ❤️

[@Innozant]

Love You Adarsh 🙏♥️ for such a wonderful appreciation

[@rasbihari1909]

Aap basic excel ka pdf video dikhaiye

[@MdIlyasShaikh]

Thank you so much, sir, it's really a very interesting series. Thanks again.

[@Innozant]

Thanks dear .. Happy learning..🙏❤️

[@brijeshshah574]

The way you explain 👏🙏👌🙌🔥

[@aaqibchaudhary786]

nice sir keet it up, your teaching method is awesome, i watch your all video, after learning from your these videos , I am in excel guru in my office

[@Innozant]

Great👍❤️❤️❤️

[@JitendraKumar-gp4do]

Sir Count If ya Sum if with filter option using kese krenege..vedio bana dijiye sir .👏

[@paramjeet975singh3]

Thanx sir... Excel ke sath pls vba ya sql pls pls

[@Innozant]

Aayega time ke Saath dear

[@ravisiripuram4654]

zabardast Sirji

[@Innozant]

❤💖💖🙏🙏thanks

[@pawanverma7220]

Amazing Video As Always

[@Innozant]

Thanks Pawan ♥️🙏

[@amaninderkaur4145]

Always a support and curious for next one❤️

[@Innozant]

Thanks Aman..Good Night 🙏♥️

[@hemantgusain1260]

It was totally knowledgeable.

[@Innozant]

Thanks Hemant Ji👍❤️

[@b.tedittech3072]

Thankyou sir for greatful knowledge and love you 🙏

[@Innozant]

Thanks ♥️🙏

[@chayankumar8061]

Sir thanks lot for your essential tutoril. please explain how to dynamic height & width in offset

[@Innozant]

Thanks ..alreday explainedm.kindky watch all videos step by step

[@sanjeevkhakre2990]

Super se upar thank you sir for your all efforts 🙏🙏🙏🙏

[@Innozant]

Thanks Sanjeev Ji..♥️🙏

[@beinspired24x73]

sir can you please make a playlist for all functtion with combination it will be easy to learn

[@akhilntu]

Sir Please tell me the dynamic reference problem if the number of rows are not same which needs toe be populate

[@tarunsehgal5789]

Thanks Sir

[@Innozant]

Thanks Tarun❤️

[@Hindi_Movies8383]

Thank you sir🙏 Indirect se to 1 second me ho ja r h ye question.😀 But Offset se v sikh liya🙏🙏🙏❤️

[@Innozant]

Yes 😊❤️🙏Sourav Ji.👍very good

[@Jitenderkumar-yp1rn]

Usefully and valuable video..... sir jii..😍😍❤❤❤

[@Innozant]

Thanks Jitender Ji🙏❤️

[@muhammadajmal6887]

❤❤❤ Thanks ❤❤❤

[@dj_gameshow8058]

Sir ise switch function se bhi kr skte hain ?

[@kinghundred]

very superb sir

[@mohammadahmed7932]

extraordinary teaching skill + superb knowledge.Sir i do not have equal rows number of all tables and i want to use sumproduct formula ,than ?. thanks

[@Innozant]

Already explained in series dear..using * symbol you may do the same

[@itcadmentor]

Thank you so much sir, aap ne bahaut achhi trick offset ki, lekin ek meharbani karein jahan hum hieght 6 detey hain, Dynamic Height ka video baney, mein ne try kia tha dynamic karney keliey lekin problem aa reh thi, sir plz ek aur video banaey, aap ki meharbani hogi. Karamullah (Pakistan)

[@VishalKumar-fj7qm]

VBA macro ka video dal dijiye

[@Innozant]

Soon

[@kishorpanara4191]

Awesome sir

[@Innozant]

Thanks Kishore ♥️🙏

[@pramodbhatt6906]

Sir, You mentioned 1,6,3 (as height & Width) pl help to make it dynamic

[@premshankar6420]

Hue Sir, Heights ko Dynamic karne k liye kya karein?

[@sagararora8040]

Thank U Sir

[@Innozant]

Thanks Sagar 🙏♥️

[@RahulPrajapati-xb2ls]

i need to know how to work sumifs formula if i need to work on daily basis and re-caluculate in auto mode instead to select complete column.

[@Innozant]

What yoi want to do with sumifs ..using offset or individual

[@ManpreetSingh-ko6mn]

What if you don't know hoy many rows to go down (the height of the range you wish to return)? In the case shown in the video, you know for a fact that the height of the dataset you wish to retrieve is 6, and the width 3. How would get Excel to automatically calculate this value, that is, how many rows to go down (your height), for example, by counting non-blank cells? The COUNTA function requires an actual range within which to count, but you need excel to find this range to begin with! I can't seem to wrap my mind around this. Please help! Thank you very much in advance. :D

[@paramjeet975singh3]

Thanx.. Sir.... Magar kya isme bhi range different different ho sakti hai..? Agra ha... To kaisa hoga... Kya manually count karna hoga... Pls help sir

[@Innozant]

Range different means..?

[@paramjeet975singh3]

@@Innozant matlb sachin ka 4 row aur 4 colums ho aur virata ke 10 row aur 6 columns ho?

[@Altaf_Alam]

❤️❤️🔥

[@ishutiwari5567]

great sir g 🙏

[@Innozant]

Thanks Ishu... Happy Learning.. Really means a lot to me..♥️🙏

[@koushikmaity3954]

Sir, Shift control enter are not working sometime at the time of array conversion.Only one cell is getting converted but other selected cells are not getting populated with array formula Please suggest its easiest way

[@salorasingh3919]

Apki reference wali class dekh li hai achche se...pr jab offset me nahi samjh aa raha...plz help me

[@Innozant]

Kya issue ?

[@user-mv1fi7zk6g]

How to solve this problem Policy no car no 4455. Dl0876 I want to match through policy no car no se without using drop-down or helper column

[@vidyashirley7885]

1000 like

[@kashisharora4563]

Sir, isko hum index reference area number wale method se bhi kr skte hai kya?

[@Innozant]

Haan kashish sahi soch rahe hain..aap area method se try krke mujhe bataiye..ki hua ya koi issue aaya..will guide you for the same.

[@kashisharora4563]

@@Innozant =INDEX(($C$2:$E$7,$C$8:$E$13,$C$14:$E$19),MATCH($G$3,$B$2:$B$19,0),0,VLOOKUP($G$3,$L$2:$M$4,2,0))

[@kashisharora4563]

@@Innozant reference error ara hai sir aap help kijiye isme plz

[@kashisharora4563]

@@Innozant plzz reply sir

[@amitchaudhary5034]

Sir mera ek doubt hai...isme reference bss index ke through hi nikalne pe answer aa raha hai but same reference jab vlookup ke through nikal raha ho toh answer nai aa raha hai....please clear kijiye ki ye offset ka ye wala feature me vlookup ke sath kaam nai karega kya?...

[@4raza]

Hi sir i am from Pakistan sir mara question hay if rows same hay 5 5 ager ya kahe 3 ho kahe 4 or kahae 5 so ham kasay isay lahay gay formula main please help

[@syedfaraz1903]

Power bi plz

[@RakeshSingh-qo5nd]

Sir interview cracker series ke ek video me bhi maine thi same comment kiya tha but apne us pe koi reply nhi diya tha. Sir iss question me reference ko as it is hi select kar k without index match and row me only match pass karne se bhi same ans aata hai to kya without index wala formula kisi point pe jaa kar fail ho jayega kya? Mai reference ke liye us comment ko search karke usse send krta hu

[@Innozant]

Aap dono formula ko test krke dekhiye static reference aur index ke through uska direct reference Lene ka Hume kya benifit mil rha hai..Debug krke btaiye mujhe Rakesh.. Approach Aapne bilkul Sahi bhi Kiya hai aur attempt bhi Sahi hai aaapka..

[@PiyushPankajJr]

Sir main answer sheet kaise share kru.

[@Innozant]

@innozantofficial telegram id

[@razamoulvi8801]

Pro Quest ka last week Solution share nahi kiye sir...?

[@Sanddystar17]

Nice sir ...😊

[@Innozant]

Proquest Harek alternate week par aata hai Raza Sahab..Next Sunday aayega na 🙏❤️

[@razamoulvi8801]

@@Innozant i thought it comes every week😅😅 sorry my bad😁

[@razamoulvi8801]

@@Innozant And what about power Quarry Series..?

[@Innozant]

Soon after power pivot series

[@gauravbhatia7987]

🙏🙏🙏🙏

[@Innozant]

♥️🙏

[@sunnykhowal3311]

Sir practice file download nahi ho rahi h

[@Innozant]

Assignment master link Diya hua hai video description me

[@RakeshSingh-qo5nd]

Sir ye likha tha maine....Sir MIS cracker series ke crack job #7 ke question number 4 me apne index and match ka use kiya hai (OFFSET(INDEX($A$5:$A$29,MATCH($L$5,$A$5:$A$29,0)),0,2,4,4) aur maine (OFFSET($A$5,MATCH($L$5,$A$5:$A$29,0)-1,2,4,4) lagaya bina index ke only match ke sath aur ans same aya to kya is short method se lagane me kisi aur question me problem ho sakti hai aur apke ans se solve ho jayegi please reply.

[@Innozant]

Sahi hai Aapka bhi output bhi same aaaya Hoga Rakesh Ji..lekin Aapka Jo refereence wo to static hai na?No. Of table Hoga to us relative position par kaise jayenge humlog? Yahan to table humara ek Saath hai but table alag Hoga to?

[@RakeshSingh-qo5nd]

@@Innozant thankyou so much sir

[@hassaanmirza3942]

5:15 pr ne 0 ki bajaye a sy height start ki. aisa q?

[@Innozant]

Dodno approach kr skte h

[@mohitchauhan7808]

👍👍👍👍👍👍

[@Innozant]

Thanks Mohit ❤️