Excel Array Formula: Mastering Excel Array Formulas | Max | Large | LEN Array Function Hindi

In this easy Hindi video tutorial you will learn about Max formula, Large Formula and Len Formula using Array Concept.
1. Using Max Function with Array
2. Using Large Function with Array
3. Using Len Function with Array
Download the Assignment Master Practice Folder here (All Example at one place)
drive.google.c...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantofficial
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#arrayformula #largefunction #Innozant #lenfunction

[@kuldeepkaur3915]

You are outstanding... feeling glad to visit our KZbin channel thankyou...no matter i is Many years ago videos but information and your efforts for explaining everything is Life time..god bless you 🙏🙏🙏🙏🙏🎉❤

[@Innozant]

Thanks dear..Really means a lot to me

[@vikaschauhan3307]

Dear Sir, Aapko mera saadar pranam! Sir maine youtube par kaafi videos dekhi par mujhe sahi se kuch samajh nhi aya tab randomly aapka videos mila sir G jaise Aapne playlist upload kari hai me step by step waise hi videos dekh rha hu sir g inse mujhe bahut kuch sikhne ko mil rha hai aap itna acha kaam kar rahe hai bhagwan aapko khoob lambi umar de aap humesha khush raho sir aaj ke time itna kon wo bhi free of cost padhata hai Sir pehli baar kisi ki videos par comment kar rha hu kirpya accept kare or aashirwad de again Thanks you So much Sir ❤

[@Innozant]

God bless you dear..Have a wonderful career ahead..Keep growing

[@sandeepaswal8944]

सर हर बार जब मैं आपका ट्यूटोरियल देखता हूं तो मुझे कुछ नया सीखने को मिलता है | आपके वीडियो मेरे जीवन को आसान बनाते हैं|

[@Innozant]

सीखने के प्रति आपका समर्पण प्रशंशनीय है

[@surendrajaiswal1857]

Thank you so much sir what a you teach, All topic are understanding to very easily. i have been watching continuously for back 8 days so excel ko lekar mere andar kaafi jyada improve ment hua hai ,so ,mai aapko again Dil Se i am saying thank you so much sir , you are the best trainer for me.

[@Innozant]

Thanks dear,Acha lga sunke aapse ki apka skills improve hua hai,Step by step video uploaded hain..seekhiye aur life me aage badhiye.

[@nanjundeshwara-593]

yours tutorial very super and easy understaning

[@RK45937]

Sir aap bahut acche teachers.

[@Innozant]

Thanks Raj

[@heeralalkumawat2132]

Sir I love you for this job ❤❤❤❤

[@subhashdhoke8439]

Sir, Hlookup with sumproduct wala video hai usme aapane jo array me row numbers manually diye, but gar data volume me ho to kya kare..mai bhot koshish kar raha hu please guide me

[@OpPhilo03]

Amazing sir. Maja aa gaya

[@AftabAhmed-uw4ki]

Sir believe me that .your excellent world one ...i like all youtubes one excellent ....🇵🇰🇵🇰🇵🇰🇵🇰🇵🇰🇵🇰🇵🇰🇵🇰🇵🇰

[@Innozant]

Thanks

[@KapilSingh0384]

Thank you sir, i am learning new topic

[@RahulKumar-sf8zt]

great sir Thanku u very much keep going

[@bhuwanchandrapathak4617]

very inspirational and easy mode

[@Altaf_Alam]

Thank u so much sir , i am learning new topic everyday by u sir ❤️ and adding value in my own life as well as others life 🙂 Sir i am becoming expert in excel day by day just because of you 🤗🙏

[@mahaboobhossain5076]

I like your videos becoz it is understandable and u are grrat in understanding

[@horrorlovestories]

Sir sum large formula enter kiya toh har cell mein same values aa raha hai 6:41 time stamp pe drag karne se. Please help sir

[@RA-rh5lb]

Sir ji Dhanyawad..

[@padmakarbadge8419]

Amazing channel

[@kkrcreationstatus6583]

I'm so happy..you learned very well

[@Innozant]

Thanks dear.god bless you

[@shrikantbadge3978]

We want to hear your story sir. Please share your journey.

[@yugalupadhyay1549]

Sir in Q.2 if you are taking range for only one row i.e. from B7:F7 and freezing it, how it is showing result for all the rows and columns. In my sheet it is showing correct result in just one row and repeating it after that. Time starts from 5:50

[@mayur_explores]

8:52 par kya keys press ki jisse range convert hokar grouped data m show hone lga

[@Innozant]

F9 dear use to evaluate

[@manavmishra1153]

Sir mere system me agar enter press kre to bhi outcome aarha h Max improvement ka and ctrl +shift +enter se bhi aarha hai. Aisa kyuu ?? Can you Help me.

[@kanhaiyayadav7502]

Your every video is amazing ❤️❤️

[@Innozant]

Thanks Kanhaiya for your valuable appreciation..God bless you .. Happy Learning 🙏♥️

[@mahaboobhossain5076]

Which array should I use help me vijan

[@nexgencomputer7961]

sir ho gya workbook calculation manual ho gya tha 😊

[@Innozant]

👍

[@AliAli-xx1ry]

Superb 👌

[@mahaboobhossain5076]

excellent video

[@avinashghanghav2239]

Thank you sirr

[@rinturoy8014]

amazing

[@kinghundred]

very good sir

[@karankapoor200]

nice video 👌🏻👍🏻👍🏻

[@Innozant]

Thanks Karan

[@learnbypassion7563]

You are awesome.

[@Innozant]

Thanks dear.. Happy learning

[@RajuKumarYadav-i3t]

sir provide same sheet what you solve the question for plz practice

[@vijaysahal4556]

nice sir 👍🏻👍🏻👍🏻👍🏻👍🏻

[@Innozant]

Thanks Vijay

[@Jitenderkumar-yp1rn]

Great tips....

[@Innozant]

Thanks Jitendra For your wonderful feedback,Keep learning.

[@akashkumar-oi1fw]

outstanding sir

[@Innozant]

Thanks Akash ji👍❤️🙏

[@mahaboobhossain5076]

Which formula should I apply

[@bhoopendraraghav9781]

Excellent

[@Innozant]

Thanks Bhoopendra Ji,Do Practice

[@harivanshgautam3424]

Very informative 👍

[@Innozant]

Thanks Harivansh ,Keep watching ,Learn and share

[@asharfali9029]

Sir sql par koi video banaiye

[@Innozant]

Jald banega

[@asharfali9029]

Ok sir i am waiting

[@pramodkumar-ke8gd]

Great Sir

[@Innozant]

❤🙏

[@kavita8390]

Awesome as always. Thanks

[@Innozant]

Thanks Kavita ji ❤️

[@rakeshmlearningentertainme6099]

nice video

[@tarunsehgal5789]

Thanks Sir.

[@Innozant]

Thanks Tarun❤️

[@Marathiboost]

Thanks sirrrr

[@lazyohlazyinstinctiveimpro1899]

great

[@nexgencomputer7961]

sir drag karne se ek hi value a ja rha hai , video me a rha hai sir please reply

[@KuldeepKumar-pm8cm]

Thank you so much for my new learning Lekin ek request hai thoda topic par dhyan do Jo itna bich me faltu ka bolte rhte ho sach me wo bahut jayada irritating hota hai please ise suggestions ki trha lijiyega. Aapki video achhi hai lekin please topic par focus Karo mtlb bolo kam karo jayada

[@Innozant]

Aapke Gyan bhare suggestions ke liye dhanyawad... Yadi aap sirf random video dekhne ke liye is channel par aaye honge to sab befaltu aur irritating hoga...is channel par JAADOO video nahi paye jate hain..lekin in depth Learning krne ke liye Jude hain to video in sequence dekhen..phir apko pata chalega ..ye faltu ki baten aur irritating baten jo apko lagi hain wo kya value add karte hain life me Main samajh sakta hu apke paas time bht kam hai isliye aap kam time me kuch amazing karna chahte hain.but yahan padhna hai to patience rakhna hoga apko..nahi to Jadoo video bnane wale bht saare channel hain..apna keemti samay kharan mat kariye Kudleep ji😊😊❤️❤️👍

[@KuldeepKumar-pm8cm]

@@Innozant sir aap to lag rha hai naraj ho gye Main aapki video kafi time se dekh rha hun mene sikha bhi hai kuchh kuchh. Or please aapko Mera suggestions galat laga to sorry but Mera koi esa intension tha nahi. But I love your video bura mat maniye sir video short kijiye 😉

[@pramodkumar-ke8gd]

Gzb Sir

[@Innozant]

Thanks Pramod Ji.❤️

[@saketmishra1470]

Sir , but I have run max in reference by using entre

[@AP-gr4ij]

Agar data horizontal ho to kaise nikale large

[@shreesaicomputercoachingin7762]

Sir apka fan ban ga m to

[@Innozant]

Thanks Shree❤️

[@ansariasjad8261]

Sir Inv. No 1 to 100 amount Hai party payment karti Hai 3 bill ka payment ek sath kis tarah find Karnge ke kon si 3 bill ka paymen aaya hai

[@Innozant]

Ye 1 to 100 invoice number hai kya?apko alag alag invoice no ka payment pata karna ha ek hi party ka? Ya kuch aur puchna chahte hain?better hoga aap sample ques bhej dein to jyada acha help kar payenge aapka

[@surendrajaiswal1857]

please explain this Question properly i will help you

[@Amit_Dahiya]

Control+Shift+Enter bol-bol k itna complex bna diya ki kuch smjh nhi aaya! 😂

[@nexgencomputer7961]

=SUM(LARGE($B$2:$F$2,{1,2,3})) drag karne se nahi a rha sir kya kana hogan please

[@noufaln3432]

Remove $ symbol and try

[@bobby002]

thank u

[@Innozant]

Thanks

[@shwetkumar1719]

Sir ek baat samaj nhi aae ek ex me large nikalne me we can use both "enter"& "CTRL+SHIFT+ENTER" and result are same but why it is not possible with "length function"

[@Innozant]

Already maine bataya hai dear ki large aur sumproduct ko ctrl shift enter ki jarurat nhi hai wo enter se executive ho jayenge.but len standard function hai wo array function nhin h isliye use ctrl shift enter se executive krne ki jrurat hogi

[@ArvindSingh-wp8hw]

Sir, I have Office 365 and I was doing this for practice but I have getting same results using the array function by Enter only, could you please let us me know that why it's working without Ctrl + Shift + Enter?

[@achalrajput4173]

Ms office 2021 m koi jrurat nhi h Ctrl+shift+enter press krne ki wo automatic detect kr leta h

[@bijinkuttappan7723]

How to share an Excel file which contains an array formula?

[@mahaboobhossain5076]

Can u make a video of students position those that are same score have the students out of 100 from different subjects in school plzzzz on request vijaan

[@vishwadeeptayde5179]

Supurb sir

[@Innozant]

thanks

[@shahzadsiddiqui5117]

i am using MS 2021 , hence it is taking directly even without ctrl+shft+entr.....!

[@Innozant]

Yes office 2021 and office 365 works on dynamic array concept

[@gauravbhatia7987]

Thnq sir

[@Innozant]

Aisa lag ra hai array isi week me finish Karne Ka irada hai😀...saare topic recap jaroor karte rehna dear

[@gauravbhatia7987]

@@Innozant sir maine advance excel kiya hai array bi kiya hai but apka formule lagane ka treeka different hai isliye muje samjh toh ati hai sath sath je bi pta lag jata iske ese bi lagah sakte aa isliye sir thnq so much

[@Innozant]

👍👍

[@SahilKhan-y6c2c]

This excel version name

[@GaganArora090]

Kahane the bhai abhi tak......bahut late aaye ho KZbin pe......

[@Innozant]

Hahaha..Koi Nahi GAGAN ..Pehle to Corona ne aur ab Aplogon ke pyar me jabrdsti aane ko majboor Kar Diya hai....ab aa hi gye Hain to ye Safar bht door tak chalega Saath..aap bataiye...chalenge Siphar se shikhar tak ke Safar par mere saath❤️❤️❤️🙏🙏🙂🙂😀

[@kartavyatiwari8583]

sir ek chhota sa excel sheet h sir main wo apko dikhana chahta hoon qki usme ek problem aa rha h plz koi solution dijiye

[@Innozant]

Ok .@innozantofficial telegram id par share kriye

[@kartavyatiwari8583]

@@Innozant sir is naam se 2 group show ho rha h ek me sirf join ka option h usme 380 member hai??

[@kartavyatiwari8583]

@@Innozant or share ka option to hai hi nhi hum apko mail kr de sir????

[@Innozant]

@@kartavyatiwari8583 @innozantofficial telegram id par bhejiye group par nahin

[@kartavyatiwari8583]

@@Innozant sir maine bhej diya h plz check kr lijiye

[@mahaboobhossain5076]

I am waiting vijan

[@rakeshbhuva1983]

Excel મા કોઈ celll મા નંબર લખો એટલે તેટલી જ row જોઈએ છે..... બાકીની row hide થાય એવુ foumula aapo

[@meriawaazhindi5217]

❤️❤️❤️❤️❤️

[@AP-gr4ij]

Aur bahut sari criteria ho usme se ki ek ka data large 1se 5 tak nikalna ho to

[@Liveconnecting]

Without using Max function Values Returning Maximum Difference Count Formula. {=D5:D9-C5:C9}

[@Innozant]

But how ?😊..Max required na?

[@harkeshkumar5735]

This will return the 1st value only. If some other value are largest, it will not be shown.

[@sethushankaranmadhavanmadh6712]

Please work on normal excel not on 365

[@Innozant]

Didnt get your dear.Kindly explain your query

[@manjit.sarania]

Ok sir

[@achalrajput4173]

Ms office 2021 m koi jarurat nhi h Ctrl + shift + enter press krne ki only enter press krne pr bhi result same aa rha h wo automatic process kr leta h 😊

[@Innozant]

Aur jahan interview Dene Gaye wahan office 2021 ya 365 na ho to ..phir kya bolen..sir offuce 365 install kar do pehle😊

[@achalrajput4173]

😂😂.....sir m isliye kah Raha tha taki office 365 Wale to iski tension na le km s km

[@achalrajput4173]

Sir aapka paid course h kya ...jisme pen drive mil Jaye ....ya phir .... videos mil Jaye Jo hm kbhi bhi dekh ske ...with certificate ...or sir yeah jo ISO certificate bna kr dete h KZbin Wale iska interview m koi benefit h ya phir .... CCC krna best h

[@Innozant]

@@achalrajput4173 Yes ,,use buy karne ke liye aap innozant website visit kariye ya team innozant se contact kariye

[@Innozant]

@@achalrajput4173 Aap innozant website visit kariye complete information ke liye

[@dashraththakor9200]

Hamre Dimag Se Bilkul Bahaar He

[@Innozant]

In sequence delhiye.. playlist.. random video dekhneg to prob hogi dear

[@khimgariya9585]

In sum of 3 products do not friz arrey

[@Innozant]

didn't get your query dear

[@khimgariya9585]

@@Innozant 2 question of this vediou ...

[@mahaboobhossain5076]

Plzzz help me vijan

[@nishachauhan9103]

👏👏👏👏👏👏👏👏👏👏👏👏👏👏

[@Innozant]

Thanks Nisha❤

[@mahaboobhossain5076]

Score of 20 students in a school of different subjects

[@Innozant]

share sheet

[@saketmishra1470]

And I can send you also if you want

[@mahaboobhossain5076]

Plzzzz help me

[@shrikantbadge3978]

Revision.

[@ganapurambalaji2146]

Like

[@Innozant]

Thanks Balaji,Keep watching , Subscribe and share to others

[@Vavgamefmindia]

haaaaaaasa

[@Vavgamefmindia]

liked very good

[@rakeshbhuva1983]

તમારો નંબર આપો સાહેબ

[@rishabhkumarytrg]

What the hell ??

[@aakashbhardwaj6251]

Khud hi smj le

[@Innozant]

👍..samjhne ke liye sequence me content learn karna hota hai 😊

[@anooparora2515]

Thanks Sir!

[@sadashivkage3133]

TQ..sir