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
Showing posts with label function. Show all posts
Showing posts with label function. Show all posts
Excel Magic Trick 508: VLOOKUP with Dynamic Table using OFFSET function
See how to create a dynamic table for the VLOOKUP function as well as a dynamic lookup area so that as you add new data or columns to the Lookup table, the VLOOKUP function and the labels in the lookup area automatically update. See how to create dynamic Named ranges using OFFSET for the Data Validation drop-down list, the VLOOKUP table and the MATCH table. See an IF function formula that creates new labels as new columns are added to the lookup table. Defined Names Name Manager dialog box.
http://www.youtube.com/watch?v=oNPVNc8cze0&hl=en
http://www.youtube.com/watch?v=oNPVNc8cze0&hl=en
Excel Magic Trick #505: INDIRECT function 2-Way Lookup Date Trouble
See how to use the INDIRECT, TEXT, SUBSTITUTE, Named Ranges, Create Name From Selection, and Space Operator to do a two way lookup when the named ranges contain dates. Then see a much better method using VLOOKUP and MATCH functions. See this video: Excel Name Trick #7: INDIRECT function, Names and LOOKUP
http://www.youtube.com/watch?v=eMB_8VMmYmc&hl=en
http://www.youtube.com/watch?v=eMB_8VMmYmc&hl=en
Subscribe to:
Posts (Atom)
