The FREQUENCY function counts the occurrences of a value within given ranges. It is an array formula and returns multiple values.
This video shows two examples of the FREQUENCY function in Excel. The second being an improvement on its standard use to include descriptive ranges and not just upper bound limits.
🔗Sample file for download
https://computergaga.com/_excel/files/formulas/frequency.xlsx
🎥 Related videos
🔥TEXTBEFORE and TEXTAFTER functions -
https://youtu.be/umPrh9uC8Ao
🔥Highlight max and min values on a column chart -
https://youtu.be/7joI63J82Sc
🔥Count values between two dates -
https://youtu.be/ZjdYKbhfiUU
📚Learn ALL the best Excel functions - https://amzn.to/3Rg87Go
⌚Timestamps
00:00 - Introduction
00:18 - Frequency distribution table with FREQUENCY
02:14 - FREQUENCY function example 2
04:20 - Column chart showing frequency distribution
🔗Connect with me!
LinkedIn ► https://www.linkedin.com/in/alanmurray-computergaga/
Instagram ► https://www.instagram.com/computergaga1/
Twitter ► http://www.twitter.com/computergaga1
#excel #excelformulas #exceltutorial