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 !!!

Excel Magic Trick #502: Excel Date Formatting & Calculations (21 Examples)

See how to: 1.Dates in Excel are whole numbers - called serial numbers. Example: 1, 2, 3, 40900, 40901. 2.The numbers represent the number of days since Dec 31, 1899. 3.The first day in Excel's world is Jan 1, 1900 4.Dates Show Date Number Format 5.Custom Date Number Format 6.Number...



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

Hot Game !!!