How To: Use FREQUENCY array functions in MS Excel

Use FREQUENCY array functions in MS Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun and Mr. Excel, the 627th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create, edit and otherwise work with FREQUENCY array functions.

This video addresses each of the following topics:

1. The basics of FREQUENCY functions.
2. How to create a Vertical Frequency Distribution.
3. How to create a Horizontal Frequency Distribution.
4. How to count unique numbers in a column
5. How to count unique numbers in column with criteria in a second column
6. How to count unique items in a column (numbers or text).
7. How to count unique items in a column that have blank cells.
8. How to count unique items in a column including items with asterisks and that have blank cells.
9. How to count unique items (numbers or text) in column with criteria in a second column.
10. How to extract a Unique List of Items from a column with a formula.
11. How to extract a Unique List of Items from a row with a formula that requires the use of the TRANSPOSE function (because the FREQUENCY function returns a vertical array and not a horizontal array).

Want to master Microsoft Excel and take your work-from-home job prospects to the next level? Jump-start your career with our Premium A-to-Z Microsoft Excel Training Bundle from the new Gadget Hacks Shop and get lifetime access to more than 40 hours of Basic to Advanced instruction on functions, formula, tools, and more.

Buy Now (97% off) >

Our Best Phone Hacks

Gadget Hacks' tips — delivered daily.

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest