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



http://www.youtube.com/watch?v=uUrI8hoj8BA&hl=en

Hot Game !!!