Excel Forum



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.