Frequency Formula in Excel in Hindi | How to use MAX and MIN with IF Formula |

Learn how to use Excel Frequency Formula to calculates how often value occur within a range of values and then returns a vertical array of numbers having one or more elements than bins_array.
1. Frequency Formula Example
2. MAX with IF Formula
3. MIN with IF Formula
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
(Playlist Folder-Basic Excel-Statistical Function-Frequencymaxmin.xlsx)
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#frequencyformula #maxwithifformula #Innozant #minwithifformula #exceltipsandtricks

[@excellenciamadhapur9174]

Sir Ji, I was seen so many advanced excel tutorials but you are the only one person giving detailed explanation with examples. I am learning and practicing so much in advanced excel functions from your videos. I like your way of teaching. Thank you so much Sir.

[@Innozant]

Oh I am pleased to have such a good audience like you and I love you all for appreciating my hardwork and even sometimes my flop efforts😌

[@SonuRaj-zp8ik]

Your way of teaching is excellent💯👍👏

[@Innozant]

Thanks Sonu

[@pareshchaudhari3985]

Nice sir mujr Aaj ye formula Kam ya gaya

[@sandeepaswal8944]

Sir, You are taking a very good initiative by giving us all free lectures.. thank you soo much sir. it really means a lot for those who can't afford to have it by spending huge amount..keep going sir Thank you again & God bless you and be happy Sir.

[@Innozant]

Thanks Sandeep,Meri Koshish yahi hai ki KZbin Platform par ,In Sequence ,Categorized ,Precise aur Beginner to Advanced Level Series ho jisse aise student jo Fees afford nhi kar sakte hain wo bhi FREE me Wahi knowledge gain Karen Jo log na Jane kitne fees pay krne ke baad bhi ek ache trainer ko search letter rhte hain.Thanks dear

[@sandeepaswal8944]

@@Innozant Your Most Welcome Sir ji. My best Wishes always with you sir ji. One Day you are the top in KZbin.

[@janakparekh4725]

I watched many videos for frequecny formula but only you have explained it perfectly. Now I konw how to use this formula. Thanaks. God bless you.

[@Innozant]

Thanks Janak..God bless You Happy learning ❤️

[@Altaf_Alam]

Sukriya sir ji 😀

[@bishtlokesh1297]

Marvellous sir

[@Innozant]

Thanks Lokesh....Learn and share

[@bishtlokesh1297]

Ofcourse

[@saurabh6543]

Smart classes sir🙏

[@SanjayMahawar1998]

Great sir......

[@tejpalsain1507]

बहुत बढ़िया सर जी।

[@Innozant]

Thanks dear

[@electricaljagat7159]

Thank you so much sir for Max if....

[@ankushnakhate9013]

Thank you !

[@heartpirates-qt6ws]

My all confusions are solved

[@saleemmalik4490]

very nice

[@satishojha6240]

Thoda tricky but practice karunga thanku very much sir.Good night

[@Innozant]

Thanks Satish ji..Good Night..Yes practice is must

[@manishpaul6052]

you should be on trending page 😍

[@Innozant]

❤️❤️

[@dktyagi80]

sir, you explain very nicely, please explain the max, min, in pivot table.

[@AbhishekKumar-nb4et]

Thanks sir

[@superNareshg]

Thank you sir ji.🙏

[@vijaysahal4556]

good 👍🏻👍🏻👍🏻

[@Innozant]

Thanks Vijay

[@hemantgusain1260]

Very helpful video.

[@Innozant]

Thanks Hemant Ji,gn

[@Abhisheksoni8738]

sir request to you can u tell me what is the work of mis executive in call centre

[@mrtikipresent518]

Nice 👍👍👍👍👍👍👍 😊😊😊

[@Innozant]

Thanks dear❤️

[@miteshvijat]

Sir aap screen recorder karne k liye konsa software use karte ho??

[@vishalkumar-qi1ky]

Thank.you so much guru ji 🙏❤

[@Innozant]

Thanks Vishal ji.Happy Learning ❤️

[@naeemulhassan1426]

Sir plz can you explain what is basic advance excel . ? And what is basic excel.? Kindly. I try to see your every tutorial bcoz I have much learn from your tutorial. Your explain style very awesome really. God bless u.

[@Innozant]

Thanks Naeeemul Sahab.. Happy learning.❤️Seprate playlist of Basic Excel is there dear

[@naeemulhassan1426]

@@Innozant sir. Very thanks for reply to me. Please one tutorial must b upload about difference between basic and advance excel functions. Regards. .

[@ubaidillahmuhammad20]

loved it. Move on.....

[@devokedevtech2750]

Excellent 👌

[@Innozant]

Thanks Dheeraj..Happy learning and share with others.

[@jaishrisaxena1083]

very nice video , u were saying that u will categorized video according Basic to Advance . Please do this , this is just my humble request. Thanks

[@jaishrisaxena1083]

I got it, I just saw, u have already made it. Thanks a lot

[@Innozant]

Thanks Jaishri,Yes it is already Categorized and in Channel home page only.

[@googleofstudyandmasti2901]

Sir ek data mai kuchh amount paid hai and kuchh unpaid and hame kisi particular person ka pending (unpaid) maximum amount nikalna hai to kya kare kaise kare koun sa formula use kar sakte hai and person ke names duplicate bhi hai then kya kare?

[@Sanddystar17]

nice and super sir 🙏

[@Innozant]

Thanks Sandeep.

[@yashpal810]

sir i want to know , how to hold the formula please tell me the shortcut key

[@bhoopendraraghav9781]

Wow amazing

[@Innozant]

Thanks Bhoopendra..Keep watching,Learn and share.

[@jaspalrana9541]

Amazing 👌

[@Innozant]

😊

[@himanshunaama13]

Sir mere pass 2016 version h usame to nhi Mila maxif minif...

[@umeshchandarana8415]

Sir, Excel is an ocean. Only difficulty with this is which Formula to apply when. Application of any of Formula to be done when is biggest question. Please guide .

[@Innozant]

Dear it is a matter of practice..You need to rehearse no. of times..It will take time to understand..but👍

[@umeshchandarana8415]

@@Innozant Thank you sir.

[@iSonuGautam]

How it will work if we will reverse this, Like get the name according to the value

[@starmodern7750]

Sir, what's your and where are you from?

[@shashik9603]

Sir cells copy karke enter karna nhi aa rahi hai

[@devokedevtech2750]

Agar sir quantity alag alag column ho to or unka hme sum krna ho to sum ke sath if kaam krega mene abhi karke dekha h sumproduct jesa kaam karta h

[@Innozant]

Array banake krega kaamm..Ctrl+shift+enter

[@pawanwakale8801]

Sir pls share the sheet of above topic because he example you took in the video its not in the sheet of frequencymaxmin,,, The given example is

[@Innozant]

Kindly download master assignment folder

[@vaishnavimarwaha8155]

Practice file is not available in statistical functions. Max Min is copied in both

[@Innozant]

Check in folder dear

[@babameraj766]

❤

[@solankihitendrasinh6748]

Namaskar sir muje max and min dono ke sath time function formula kese laga a please sir

[@Innozant]

Kya chahte hai. Formula calculation

[@meditationmusic6482]

Sir ji.today I do work in excel.so I use formula...then I put (,)coma so can't going to next function. But I use (;) cemiculman so can.....why sir pls advice... Tq.

[@tjr1421]

Sir the above frequency practice data sheet is not available in the assignment folder.

[@Innozant]

It is there in assignment folder.kindly download it from Assignment master link

[@tjr1421]

@@Innozant I have checked sir. sheet named frequency contains max,min,Maxa n Mina data in it.

[@user-jq8ej8bg2m]

Sum ko nested if ke saath kaise use kare

[@Innozant]

Jaise apki requirement hai uske base par..kya karna chahte h aap?

[@user-jq8ej8bg2m]

@@Innozant my doubt is clear sir. Thank you for giving reply.

[@arunsaini3340]

In 2 example samsung maxif ,how I used in excel 2007 there is alternate??please reply anyone

[@arunsaini3340]

@Innozant please reply

[@03Vikas]

Namaskar sir meri ek sheet me filter ka hal kar do sir

[@nitinbajaj9436]

Hello Sir, Hope you are doing well, I need your help in one thing, I have data of call center executives in a pivot table, their data are arranged as, their "Available time, break time, aux1, aux2 there are multiple auxes for a single rep, so do we have any formula which can give us difference of two auxes are more than 50 minutes?

[@nitinbajaj9436]

Sir pls reply my question

[@yashpal810]

Sir i have an query in the same question , if i want to get SUM OF total qty of one product in one cell, sir please tell me how we get it please sir solve my query ASAP , FOR EXAMPLE------samsung qty 15,25,30,40 etc . how we get total of samsung 110 in one cell in question.

[@addicted4253]

use Sumif Function

[@rohitmehra1499]

Sir muzy 10 agent ki team mai unke production k acoding muzy unhe point dene hai jiska sabse jada point hai use 50 number dene hai use kam ko retio k acoding no. Kam hote jay vo kse kre

[@Innozant]

Haan to puchiye kya issue aa ra hai jab formula apply krte hain..kys use kiya hai formul btayen

[@rohitmehra1499]

We have use =if(G6=max(g6:g12),50,g6/max(g6:g12)*50) ye use kre hai result aara hai but dived kyu kra then × kyu kra ye muzy smj ni aaya isme

[@ajitkumarsahoo3914]

Pl guide. What would be excel formula for " Value of a cell to be calculated as % of another cell value subject to minimum and maximum value." E.g 5% of a cell value subject to minimum of 100 and maximum of 1000

[@Innozant]

Share your excel aheet with query explanataion👍❤️

[@ajitkumarsahoo3914]

@@Innozant Limit Charge @ 0.5% (subject to min of 1000 and max of 5000) 1,00,000.00 1000 7,50,000.00 3750 15,00,000.00 5000

[@naveengaurav9514]

hello sir es video ke practice excel File drive may nhi hai Plz chack and upload file as soon as possible

[@Innozant]

Hoga dear .Kindly check in Play list folder

[@naveengaurav9514]

@@Innozant sir max min wali file ka data frequency wali file may past hai plz check

[@gauravbhatia7987]

🙏

[@virendersroha1754]

Sr aap konsa office use krte ho 2013_14_15_16 ya 2019 ya ofc 365 but 2010 k baad k office bhoot hang krte h long deta me hang krte h bhoot ofc me bhoot prob hoti h

[@Innozant]

Nahi aisa nhi hai .main to alag alag topic padhane ke liye alag version update krta rhta hoon..Apke system ka issue hoga.offcice ka issue nhi h hang hona .

[@virendersroha1754]

@@Innozant pta ni sr ofice 10 to bhoot achaa chalta h But isse upr k version slow ho jaye h or system me ram 6gb or hard drive 1000 gb h

[@Innozant]

Phir to issue nhi hona chaiye .

[@virendersroha1754]

@@Innozant sr ye exl ki he prob h mne bhoot ofc me pucha h long deta me nhi chalta h new version exl

[@Innozant]

Haan bht jyada mb ka file hoga tab issue hota hai . otherwise koi issue nhi hai..main to latest use krta hu version..but 2007 se acha koi nhi h

[@naeemkhan-tm9hx]

First

[@sourabhsharma6125]

2 questions h

[@Innozant]

?

[@sourabhsharma6125]

Hlo

[@Innozant]

Hi

[@dhakafady774]

kkhkh