Excel Array Formula : Frequency Function in Excel | Transpose Function | in Hindi

In this easy Hindi video tutorial you will learn about frequency formula.Frequency Formula tells how often values occur within a set of data. So if you want to find out how many time number "10" repeats in a data set then Frequency Formula can find that for you,Even it counts of a value below or above a number as well.
1. Frequency Formula in Excel
2. Transpose Formula in Excel
3. Countif formula in excel

Download the Assignment Master Practice Folder here (All Example at one place)

Let's Connect:

#arrayformula#frequencyfunction#Innozant #transposefunction

[AnupKumar-oejb]

Great Sir, what a ways to tell the formula. I always learn from your videos..

[karankapoor]

array functions best or apa kisi function KO bata ta ho to maja a jata h tabhi ma khata hu Ki apka jassa Koi nhi sir 👌🏻👍🏻👍🏻👍🏻🙏🙏🙏. thanku sir

[sandeepaswal]

सर आपने Array Formula और Frequency Function बहुत अच्छा सिखाया | मुझे नया सीखने को मिला आपका बहुत बहुत धन्यवाद सर जी|

[shantanumaity]

The array function is amazing, it's very interesting.

[vipintyagi]

Great Sir, I'm learning from your video. It's good

[rishimandal]

Sir your knowledge totally advance Level, app ko salut ❤️❤️❤️.

[Altaf_Alam]

Sir i like your teaching technique as well as your smile 😊

[KuldeepKumar-pmcm]

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

[AlimKhan-blsh]

G han sir frequency kaam nahii kar raha.. Countif or frequency ki value different aa raha.. Bht acche se dekh liya mene

[dgmgeasternrailway]

Sir, I like your videos, your teaching concept is excellent. can you plz make one long video for Array Concept with different examples, if possible.

[tannupathak]

Sir Frequency formula answer is not correct in my excel sheet

[AlimKhan-blsh]

Sir pata chal gaya k kya problem thi.. Data range me -2 type ho rakha hai.. Check kariyega aap..

[Demon]

sir agar ap sms dhekho to mera ek question he, frequency mere system pe thik se kam nahi kar raha, maine sab thik kiya he ctrl+enter mera value galat dhikha raha, sab bohot bar kar k dhekha lekin ho q nahi raha, me to apko idhar sms pe photo video vi nahi de sakta ki ap dhek k sahi kar doge,

countif se hua, but itna easy chij q nahi ho raha

[AlimKhan-blsh]

Sir ek baat bataiye.. Ye jo array aap sikha rahe hai.. Isko me kab sikhu besic excel k baad ya vlookup series k baad..

[PradeepKumar-yptc]

Sir if the internal is irregular, will the frequency function still work?

[Abvi]

There is difference between the Frequency Answer and count if, Count if answer is coming 4 as per the formula used, But with frequency it is coming 5.

[abhishekjadli]

Sir. Mera frequency wala ans. sahi nii ara assignment s khud krne ki koshish krri.
Some doubts.:-
Aapne Bins m krke value kyu lii h, directly 20, 40, 60 kyu nii likha?
Or sir Frequency k andr kisi bhi selected array ko freeze nii krna kya?..

[hairavyadav]

in frequency we didn't expected out put if some enter negative value

[dktyagi]

Sir, Can I write the <=E6 which generally used.

[arunkumarsinghark]

🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l