How to Use an Array Function in Excel - The Frequency Function

In this tutorial, I demonstrate how to use an Array Function - The Frequency Function to summarize the Age Brackets for our sample data. If you have never used an Array Function in Excel, you will appreciate the step-by-step approach that I use in this video.

If you watched my previous YouTube video, I used a Pivot Table to summarize by Age Brackets. Now you can compare and contrast two different approaches to analyzing your data.

Danny Rocks
The Company Rocks

[rocky]

You are the best excel Guru in the world. Thank you for this video.

[DannyRocksExcels]

Thank you! I appreciate your kind words.

Danny Rocks
The Company Rocks

[DannyRocksExcels]

My pleasure. Thanks for adding your comment.

Danny Rocks
The Company Rocks

[AnasAlalwani]

thanks you Danny amazing job شكرا جزيلا
in Arabic thanks you

[DannyRocksExcels]

Thank you - in all languages! I appreciate you adding your comment.

Danny Rocks
The Company Rocks

[DannyRocksExcels]

Thank you for your kind words.

Re: My video tutorials. I price them as low as possible. I try to make them affordable. However, I cannot "give them away."

I have several additional video tutorials that are almost ready for publication.

Sincerely,

Danny Rocks
The Company Rocks

[WhaoIfeelgood]

These tutorials are amazing ! I can follow every step you do carefully and I can always learn something new from your videos ^_^

[DannyRocksExcels]

Hello Avinash -
Since I do not have a copy of your data, I have to make a few assumptions. Since you have control over the Numbers that you use for your Bin Array, try this: Use the number 1 as your starting point. Then the number 10, etc. Ensure that you Bin Array is sorted in ascending order numerically.

Also, ensure that you select the range of cells that will contain the results of the =FREQUENCY() Function. This MUST match the dimensions of your Bin Array.

Danny Rocks
The Company Rocks

[avinashabraham]

I have been trying to get frequency distribution table looking at this video. I have run into a challenge. You have used bins as the largest number for a particular range eg 10 should capture all ages less than 10 but while I am following your instructions am not capturing all ages less than 10 in the range, except it only captures the age specified as 10. Please help.