Completed
) Re-organize Order of Logical Tests in IF Function to create a more efficient formula.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Array Formula - Add Daily Rainfall 5 AM to 5 AM Next Day - Most Automatic
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction and description of reporting requirements
- 2 ) Date and Time Number Formatting and Time Formula for Time Equivalent for Date Start Time.
- 3 ) Count Unique Date Array Formula. See the functions FREQUENCY, SUM and INT. See two versions of this formula. One version converts positive numbers with the Logical Test Greater than Zero and a Doub…
- 4 ) Array Formula to Extract a List of Unique Dates that assumes that we may not have a complete list of sequential dates, and there is a variable Start Time. See the functions AGGREGATE, ROW, ROWS, I…
- 5 ) Formula to add rain totals using SUMIFS & IF Functions and criteria based on the start date-time.
- 6 ) Array Formula to Extract a List of Unique Dates that assumes we HAVE a complete list of sequential dates. See the functions, AGGREGATE, IF, ROWS and INT.
- 7 ) Re-organize Order of Logical Tests in IF Function to create a more efficient formula.
- 8 ) Add new data and test formulas and reporting system.
- 9 ) Summary
