Excel Forum
Similar Content
Excel VBA - Create an Array - 3 ways
Tutorial: Ill show you three different ways to create an array in Excel VBA and Macros and how to ge...
Easily Input Complex Functions in Excel
Tutorial: In this tutorial I am going to show you how to easily input complex Functions in Excel. To...
Loop Through an Array in Excel VBA Macros
Tutorial: I'll show you how to loop through an array in VBA and macros in Excel.  This is a fairly...



Excel Magic Trick 627: FREQUENCY Array Function (10 Examples)


Topics about FREQUENCY array function is this video:
1. Basics of FREQUENCY function -- see all aspects of how this function works
2. Create a Vertical Frequency Distribution
3. Create a Horizontal Frequency Distribution
4. Count unique numbers in a column
5. Count unique numbers in column with criteria in a second column
6. Count unique items in a column (numbers or text)
7. Count unique items in a column that have blank cells
8. Count unique items in a column including items with asterisks and that have blank cells
9. Count unique items (numbers or text) in column with criteria in a second column
10. Extract Unique List of Items from a column with a formula
11. Extract 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





Got a Question? Ask it Here in the Forum.