Excel LARGE and SMALL Functions | How to use Array Functions LARGE and SMALL in Excel

Learn how to use Array Functions Large and Small in Excel.
1.Large Function Example with Explanation
2. Small Function Example with Explanation
3. How to Add Top 3 Largest Number
4. How to Add Top 3 Smallest Number
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
(Playlist Folder-Basic Excel-Statistical Function-largesmall.xlsx)
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#statisticalfunction #maxandminformula #Innozant #maxaandminaformula #exceltipsandtricks

[@ManojKumarBaghel1432]

Guru ji, Aap Sach main guru ho,. Aaj ke time main Kon free main padta hain aap Sach main guru ho. Thanks guru ji

[@Innozant]

Thanks Manoj Ji ..Padhiye aur life me aage badhiye yhi wish meri

[@remarkablegraphic_designer3668]

Not only True Guru rather Legend Guru.... @innozant i tell you that you should start your franchise branch in all over world. No one here like you. दिल से और मुफ्त में पढ़ानेवाला एक इंसान नही होगा पूरी दुनियाभर में

[@satishojha6240]

Again nice video sir aap bahut hardworking hai wo din dur nahi jab candidates youtube par excel search karega aur aap ki playlists sabse top par rahegi.Good night Sir

[@Innozant]

Thanks Satish Ji for best wishes ,Yes m trying hard to make awesome content.

[@jaishrisaxena1083]

@@Innozant I totally agree.

[@ajinkyashinde1778]

Working as I MIS executive from last 3 years.... but the way to teach and explain its really outstanding and I am very glad to have you here for us.. abhi to bahot kuch sikhna he sir. ❤️❤️

[@Innozant]

Thanks Ajinkya for such a lovely comment,Aplogon ke aise comment aur seekhne me interest mujhe aur DIVE DEEP Concept seekhane ke liye motivate karta hai..Yes Sure Ajinkya..Ye to trailer hai..Picture to sirf banki nahin salon tak chalni hai ..😀

[@rajeevpal2768]

@@Innozant sir, I want learn mis from you tube but I am so confused that how to start it. Can u give me some suggestion.

[@helloworld2041]

@@rajeevpal2768 do you become mis?

[@poulomidevroy6265]

Sir, watching your videos everyday has become an addiction.... Hats off to you.... SALUTE

[@Innozant]

Really means a lot to me

[@sandeepaswal8944]

प्रणाम सर जी | सर आपने LARGE & SMALL Functions बहुत ही अच्छे से समझाया | सर आप महान हो | धन्यवाद आपने एक्सेल शीट में मेरे नाम का उल्लेख किया है | Sir You are a lifesaver.

[@Innozant]

Thanks Sandeep Ji

[@DivyaPrakashAnmol]

Good afternoon sir 🙏🙏 The way you are teaching to all of us is really awesome. But i have a question when you implement the small function then the output became 33,66,and 112 but here your output is 33,66,113 . How ?

[@vivekverma9691]

Nice sir...though i don't require much excel in my job but ur way of teaching has increased my interest and now i just get hooked to ur videos as i get the time .

[@Innozant]

Thanks Vivek ji..Happy learning Dear. Thanks for your appreciation..really means a lot to me ❤️🙏

[@asadulislamasad4985]

Best teacher ever❤️

[@Knu_804]

आपके विडियोज़ मुझे बहुत हेल्प करते है , बहुत बहुत धन्यवाद सरजी , इतना सब कुछ सीखने के लिये दुसरे लोग न जाने कितनी कोचिंग फीस मार लेते है , एक बार फिर से धन्यवाद ।

[@zaibunnisa2290]

Thank you so much sir. You deserve more SUBSCRIBER and more views. You are very good teacher. Thank you sir.

[@Innozant]

Thanks dear for your valuable appreciation..Happy learning ❤️

[@javedpathan4088]

Aap bahut acche se kisi bhi topic ko explain krte ho sir

[@Innozant]

Thanks dear

[@aabdullahhaasnain7033]

Your story telling was enjoyable.

[@Innozant]

Thanks

[@aakashverma3590]

Wow sir 🙏🙏🙏🙏aap bahut achcha padhate hai mai aapke video enjoy karte karte seekh jata hoo

[@Innozant]

Thanks Aakash ji aapke valuable appreciation ke liye..Happy Learning ❤️

[@manojjrkhiara240]

Your way of teaching is very nice. Thank you Sir.

[@Innozant]

Thanks

[@GaganDeep-mj5hi]

Very nice.. the way you explain the logic

[@shahzadsiddiqui5117]

corona ko bhi sir aapne prha dia....:P heheheheh by the way bahut hi achi video h sir... ye maine aaj tak nhi seekh atha zaroorat nhi hui , pr ab kabhi hui to will definitley use it

[@muhammadsaqlain5162]

Kya bat hai sir is man koye dout nahi hai k karona sirf school aur collage man hai aur kahi nahi hai Pakistan man bhi ayesa hi tha thank you sir very much.

[@subhajitmazumdar7332]

Thank you Sir...thank you very much....

[@sundarsingh2981]

Dolar kyo lagaya hai

[@mysmartkitchen6666]

Excellent technique

[@Innozant]

Thanks

[@anooparora2515]

Thanks Sir!

[@nitinrathod3330]

Can u pls tell me if I hv to put comma instead of range of list

[@Altaf_Alam]

Happy new year SIR in advance ❤️🥰

[@MonsVurivoj]

Thank u so much

[@vinayvemul8456]

Sir app tho excel ke genius hoo

[@Innozant]

♥️♥️♥️

[@vishalkumar-qi1ky]

thank you so much sir. this video is very help full.

[@Innozant]

Thanks Vishal Ji

[@GaganDeep-mj5hi]

Very nice..

[@meditationmusic6482]

Sir ji....soooooooo nice 🙂

[@Innozant]

Thanks Sanoj Ji..Happy learning dear

[@BROTOTECH]

Thank you Sir

[@Innozant]

Thanks

[@rjraviraftarup7553]

Very interesting topic 👍

[@Innozant]

Thanks

[@tarunsehgal5789]

Well explained.

[@Innozant]

Thanks Tarun sahab❤️❤️🙏🙏🙏

[@narayanlohar204]

Very nice video sir

[@Innozant]

Thanks Narayan

[@RA-rh5lb]

Thank you sir ji. Idar sumproduct ko nahi use kar sakthe hai?

[@bibhakumari8531]

Very nice sir

[@Innozant]

Thanks Bibha..Keep learning..Keep exploring ❤️

[@imsuvel]

Thank you sir🙏🏻 thank you so much

[@PawanKumar-lc3du]

sir ji, small sr. no. 3 is 112 hon chhiye in place of 113

[@sawaimalhi8439]

so nice sir

[@Innozant]

Thanks dear

[@myrasworld7919]

I have learnt a lot from you sir. The way you explain is just fabulous. But here I am unable to understand that, how in the smallest 3 function 113 came ? The answer must be 33,66 and 112 instead of 113.

[@Innozant]

Thanks..kindly check and reapply the forumula may be I missed to freeze the cell reference

[@myrasworld7919]

@@Innozant sure sir Thanks a lot

[@paras5861]

Maza Aa gaya

[@Innozant]

Thanks 🙏❤️

[@cartoonloversop6019]

Sir i am happy to learn very important & useful function Large and Small Sir just for your information small main kuch mismatch hai jaishy ki 1st - 33 ok 2nd - 66 ok but 3rd ka answer 112 hoga per 113 aa raha hai Thanks for Teach us

[@Innozant]

Ek baar data set check kr lijiye may be flow me miss ho gya hogammsheet se practice kar lijiye

[@bhoopendraraghav9781]

Very very Nice video

[@Innozant]

Thanks dear Bhoopi..Gn

[@bhoopendraraghav9781]

@@Innozant good night sir have a nice dream

[@vikassinghjayara510]

Hello Sir Nice video ☺ I have learned a lot from you. Thank you so much Sir I am practicing of Sumif. Could you please help me to find out the total productivity of weekday by using Sumif. I got the answer of total productivity of weekend. Actually I am unable to understand what should be the criteria should I select for weekday.

[@VinodThakur-v2b]

व्हेरी युसफूल इन preparing सिलेक्सन लिस्ट ऑफ फायनल एक्साम इन लेस टाइम 🙏🙏🙏

[@pandharinathjoshi6565]

Nice topic, good speach Share Top 10 Products with Highest purchase or sale sir

[@Innozant]

Thanks dear Joshu sahab..👍❤️🙏

[@hemantgusain1260]

Thanks for explaining, but something went wrong in small function because 3rd smallest value was 112, but your result showing 113.

[@Innozant]

Na.Na..may be wrong data select kiya hoga...Check Krna aap Hemant..it's working fine

[@hemantgusain1260]

I was talking about your video, but I download your practice sheet where result was correct

[@pawanverma7220]

Jo Array Range Select Ki Hai, Uske Pahle Cell Ko Freeze Karke Dekho, Value Correct Aayegi

[@Altaf_Alam]

@@Innozant sir aap cell reference fix karna bhul gye the small & large mein 😅

[@Altaf_Alam]

@@Innozant thanks sir 😍

[@gauravbhatia7987]

Good sir

[@Innozant]

👍❤️🙏

[@pa2happiness13]

👌

[@fermion4945]

Sir Yeh video Mai 2024 Mai dekh rha hu aur apka corona entertainment sunkr mujhe lockdown ki yad aa gyi 😂😂😂

[@Innozant]

Hahahaha

[@bishtlokesh1297]

Sum(large, array, {1,2,3}) Sum(small, array, {1,2,3}) and ctrl + shift + enter

[@jaspalrana9541]

Amazing 👌

[@Innozant]

Thank You Rana Sahab,Hope you like the video and learn the concept of Statistical function

[@jaspalrana9541]

@@Innozant yes I liked the video and learn the concept of statistical function. Thanks for making these valueable videos for us.

[@pawanwakale8801]

Sir Please can i get the video for MACROS, VBA , SQL because our organisation want an xecutive who had some knowledege of these Topics

[@Innozant]

Abhi inke videos nhi bane hain..aap live class sql ka join kr skte hain...videos kuch time baad aane lgenge

[@pawanwakale8801]

@@Innozant kab hota hai aur kitne baje,

[@Comed-King-Deb]

Hi sir good Evening, Sir Please prepare one topic how to calculate TAT MIS please one session video post. I have more doubt .

[@someonefrom2002]

"Corona school me class le rha hai" Gajabb sir ji😆😆😆😆👌👌👌 Kahi Corona graduate na ho jaye🤣

[@Innozant]

Hahahaha..thnks..hope you like ❤️❤️

[@kishorebhengra5307]

How do I use large function between 2date please make a video for it

[@Innozant]

👍❤️kindly watch sumproduct series

[@vivekkalshan3589]

Sir large formula se ek data me per row top 3 value kaise highlight kare tell me sir

[@Innozant]

Per roe top 3 kehna ka matlab?

[@ManjeetSingh-th4fu]

Sir. Large function m 2nd and 3rd position m result same (174) aa raha h?

[@KunalSingh-oy1ny]

Sir If i want to know name also of that person who has done that sale on that position. then how can i do that.

[@Innozant]

using index match you may find the name of the person as well

[@adnanshoukat807]

sir... sumproduct with large and small is py b video bna dn.

[@Innozant]

Kai interview questions me sumproduct with large and small ke Ques kiye Hahn.ok separate video nhi bnate h.

[@puransingh-sx2tk]

Play list jaldi le kar aaye sir or ... Excel vba par vedio bana sakte hai aap basis and advance

[@Innozant]

Yes VBA Series bhi start karenge..Pehle Advanced Excel ke upload ho the hain..abhi..thora time dena hoga dear.

[@MD-pe7so]

If the Arrey is not group, but different cells like C10, F10, I10, L10, O10, S10.

[@dirghangiamit9997]

Including KORONA you are 1000000000e% right as always

[@Innozant]

Hahaha..One of the best Lovely comment i seen...Thanks. Happy Learning❤️🙏

[@DeepakSharma-gv6oh]

sir jab duplicates values hoti h to problem hoti h...2nd or 3rd poaition pe same value deekhata h to isko kaise sort out kare??? ye mujhse intervew m pucha tha

[@ajaysaroha2539]

Sir I raised questions sir you find one by one first 191 second largest 174 value 3 largest 167 it is ok but add 3 largest value it is ok 191+174+167=532 but if calculate add 3 larget 191+174+174=539 is different output why ? Clear it sir?

[@Innozant]

Why if differ..kindly recheck again with aaplying this formula on different data and then evaluate the output is really get or wrong and let me confirm.aisa hona to nhi chaiye..

[@ajaysaroha2539]

@@Innozant sir,aisa ho sakta h kya ex 113,113,125,135 function pick 113,125,135 means same occurence reject

[@shivprasadmishra268]

Sir your addition of 3 smallest is 211 but in above table where you find 3 small values total of these values are 212 why sir please explain me.

[@Innozant]

May be I missed any argument kindly check in practice sheet and Rectify it

[@rameshchoudhary2903]

This is because he did not freeze the range while dragging down the formula

[@jatinramaiya6206]

How to i get name also of large value

[@Innozant]

use index match to get name

[@jatinramaiya6206]

@@Innozant thank you i will try

[@jatinramaiya6206]

@@Innozant working fine thanks excle master

[@mehfuzmj2789]

Top three and and top 5 agar name ke sath Janna he tu , sir???

[@sweetybalhara6679]

suppose, 1 column me data h or mere pass word h "online" ab jis b column me online word use hua h uske same automatic "online" likha jaye Koi aisa FORMULA h to btao plz.

[@deepaksharma-gj5ru]

sir ek doubt h jaise ek list h (1,2,3,4,5,6,3,6,5) ab isme se hume largest second largest number nikalna h to apke method se kiya to bh largest and second largest yh 6 hi dikha rha h asa kyu sir?

[@Innozant]

ap kya chahte hain output dear

[@deepaksharma-gj5ru]

@@Innozant sir isme largest and second largest number dono hi 6 a rha h formula is =large(range,2)

[@vijaybisht3161]

Sir topic kaise kaise phdna hai?? Day wise?? Wo link share kr do..

[@Innozant]

Playlist hai announcement name se usme jaiye wahan batay gya hai ek video mis learning process me ki kaise padhna hai syllabus

[@pharmacareer279]

sir Rahul Sarkar 112 SMall मैं क्यों नहीं आये. और टॉप थ्री मैं जो SUM की हैं वो दोनों टेबल की मॅच नहीं हो रही हैं. कृपया मैं इसे समझ नहीं प् रहा हूँ. क्या Array freeze करना चाहिए?

[@reyazazam7708]

Sir, There is a problem in E12 the value should be 112 but it is 113. Which is wrong I think that you r doing some mistake

[@dhakafady774]

wow

[@techmaniaappsfuninfo5133]

draging nahi horaha sir ....ist 7 ka bad error da raha hai .....ye index no ka masla hai ya kya hai???

[@PavanKumar-cm2sz]

gr8

[@Innozant]

Thanks

[@PavanKumar-cm2sz]

@@Innozant sir mera ek query hai.........kisi Amount column kuch data hai or agar mujhe ek value chahiye but wo value us Amount column data me nhi hai to kya mere us particular value ka combination bana kei usi amount column se result de sakta hai kya ye posiable hai.......or ye nhi ki mujhe exact value chahiye uske ass pass ka value bhi bata de to bhi chalega......???? Plz rpl sir

[@achalrajput4173]

Sir, Jo Aapne sum ka formula lgaya h usme answers Kuch or h or agar hm in values ko one by one alag s sum kre to answer Kuch or aa rha h ...asa Kyu ho rha h sir 🤔

[@prithvisahay269]

Only One word for you Sir ....Thanks 🙏

[@Innozant]

Thanks dear...happy learning ❤️

[@VivekMeenaJahazpur]

Sir, Large 1,2,3 me second aur third 174 h same to isko ye nahi bata raha jabki top 3 ki total me ye 174+174+191 ka sum kar raha h

[@umairzahid3743]

SIR, jo largest ka sum hai wo 532 aa raha magar yahan 539 aya hai?

[@Innozant]

Recheck kijiye ek bar. may b kuch miss Kiya ho

[@pawanwakale8801]

Aakanksha Shrivastava 220 Tarjit Singh 192 Vinny Pal 181 Tina Goswami 174 Bhoopendra Singh 174 Ankita Sharma 167 Sandeep Aswal 155 Sonu Singh 154 Jyoti Chaudhary 113 Rupesh Pandey 113 Rahul Sarkar 112 Sir isme jab large nikalege tab output kya ayega 220 192 181 ana chahiye na but output toh 220 181 174 aa raha help sir

[@Innozant]

Aisa kyu..kuch mistake hua hoga formula apply krne me..ek baar check kijye aur use rectify kar lijiye.thanks 🙏❤️

[@NirmalKumar-cp4nf]

Sir apse eak request hai ki kya ki next video ka link same video me dal de discreption me

[@Innozant]

Next aane wale video ka link pehle kaise daalenge dear.jab video upload hoga tabhi to uska link create

[@bishtlokesh1297]

Yes please ek video bna do or usme kaise study kare bta do pura structure MIS KA

[@Innozant]

Haan bht jald ..Lokesh ji

[@pawanwakale8801]

Sir yeh example me jab isme large value find kiya ! Num error aa raha tha ,, aur jab dollar sign remove kiya toh correct answer de raha tha aisa kyun

[@Innozant]

Dollar sign se kya fark parna yahn?

[@pawanwakale8801]

@@Innozant Pata nhi mai $ ka sign use kiya toh error aa raha jab dollar hataya tab answer aa raha ,,last time bhi koi example tha jisme dollar sign se error bata raha aur jab dollar nikala answer aa raha tha

[@sunilrao7895]

Sir there is a mistake in small function like third smallest amount should be 112 and not 113

[@Innozant]

Kindly freeze the data range

[@9675.]

Sir The sum of top three =532 Bt it's not Small three also wrong

[@vijaysahal4556]

Hi sir large functions main range freez kriye result kese aayenga see

[@Innozant]

Bta diya h already dear desc me..its yourtube video ek baaf upload ho gya to edit nhi kr skte h na..😀

[@umairzahid3743]

Sir smallast third value 112 honi chahye thi. Laikin 113 aaya sir

[@Soft-tips-tricks]

Explain picture lookup

[@Innozant]

Yes it's coming soon in Index match series..

[@Soft-tips-tricks]

@@Innozant ok sir

[@Soft-tips-tricks]

Refer any book for advance excel

[@Innozant]

There is no need of Book..Will Upload each and every topic in depth .Have patience.

[@Soft-tips-tricks]

Ok sir thank you

[@iamsainipawan]

Sir small value mein 112 ke jagha 113 value kaise aiye please explain sir

[@Innozant]

Freeze nhi kiaya hais. Sayad range isliye wrong output throw hua hoga kindly rectify it

[@arjunnegi4591]

sir $ sign ki wajah se small large nahi dikha raha hai error show aa raha hai

[@abhineshkumar1273]

How to use large and small function with round formula.

[@Innozant]

In which perspective like..eg? Kya chahte Hain query puchiye

[@jatinkumar6859]

Sir smallest ka total wrong hai or largest ka bhi total please check

[@Innozant]

Oho aisa kyu..let me check..ek vaar aap apply krke dekhna.may b array use Kiya hoga Maine aur ctrl shift enter press nhi Kiya hoga

[@mohdjakir6719]

Sir Small function me sum 212 ayenga aur yaha par 211 aa raha hai?🤔 Aur large me sum total hoga 532 ayenga aur yaha dikha raha hai 539 please sir reply

[@Innozant]

May be ctrl shift enter press nhi kiya hoga..ek baar apply krke issue ydi kuch hai use rectify kriye ..still issue let me confirm

[@gulabprajapati92]

If numbers are given 1 to 10. Then how will find out - lowest to highest & highest to lowest with the help of formula without sorting.

[@bishtlokesh1297]

I'm advance excel learner and I want SQL, VBA, and TABLEAU and advanced excel video

[@Innozant]

Sure ...

[@sonalikundu4981]

Sir mujhe basic ka link de dijiye Mjhe pehle basic hi sikhna hai

[@Innozant]

Hi Sonali...aap Announcement Playlist me Jake ek video hai -MIS LEARNING PROCESS use dekhiye usme kaise padhna hai wo completely bataya gaya hai. Saath hi videos in sequence playlist ka link bhi diya gya hai video description me.

[@manishjhatalks6905]

🎉

[@AlimKhan-bl5sh]

Sir isme apne jo small number jo nikala tha top 3 ka to apka answer aya.. 33,66.113..lekin hona chaiye 33,66,112

[@AlimKhan-bl5sh]

Samjh gaya sir... Apka answer isliye wrong aya tha.. Ku k apne array ko fridge nahi kara tha.. Jisse range niche move ho gayi hogi

[@pawanwakale8801]

Yeh Large example me table top three highest value show karta toh isme 191 top par bata raha aur 181 2 times hai toh woh ek hi bar bata raha aur uske bad ki value 174 output me dhikha raha

[@Innozant]

Galat value utha ra hai kya?

[@vijaysahal4556]

Nd small functions bhi check kriye range lock nhi h tabhi last 112 ki jgh resul 113 aarha h

[@Innozant]

Haan .. Already mentioned hai dec me..lock the range and apply the formula.there is no issue at all

[@22aliahmed]

Sir small formulla with name

[@Innozant]

query phir se puchiye ek baar

[@narenderkumar-nk5eh]

Add 3 ka sum wrong aa rha hei 239kaise aayga 🤔