SEQUENCE of times
In this video, we'll look at how to generate a sequence of times with the SEQUENCE function...
Dave Bruns
SEQUENCE of dates
In this video, we'll look at how to generate a sequence of dates with the SEQUENCE function...
The SEQUENCE function
In this video, we'll introduce the SEQUENCE function. The SEQUENCE function lets you generate numeric sequences, which can be used for dates, times, and more...
Unique values with multiple criteria
This example uses the UNIQUE function together with the FILTER function. The FILTER function removes data that does not meet required criteria, and the UNIQUE function further limits results to unique values only.
Working from the inside out, the FILTER function is used to collect source...Read more
Sort by custom list with SORTBY
In this video, we'll look at how to sort with SORTBY function using a custom list. We use the custom list to specify a custom order...
SORT and SORTBY with multiple columns
In this video, we’ll look at how to sort by multiple columns with the SORT and SORTBY functions.
...
Unique values with criteria
In this video, we'll look at how to use the FILTER function together with the UNIQUE function to limit results using logical criteria.
...
How to count unique values
In this video, we'll look at how to count the unique values returned by the UNIQUE function, together with other functions like FILTER and COUNTA...
The UNIQUE function
In this video, we'll introduce the UNIQUE function. The UNIQUE function lets you extract unique values in a variety of ways...
Parse time string to time
In this example, the goal is to parse a text string into a proper Excel time.
First, note that the cells in F5:F13 are formatted as Text prior to entry...Read more