How to generate random dates
In this video, we'll look at how to create a list of random dates with the RANDARRAY function...
Dave Bruns
Range contains specific date
First, it's important to note first that Excel dates are simply large serial numbers. When we check for a date with a formula, we are looking for a specific large number, not text.
This formula is a basic example of using the COUNTIFS function...Read more
How to see arrays in formulas
In this video, we'll look at a few ways to see or visualize arrays in a formula. One of the best things about the new dynamic array formula engine in Excel is that it's much easier to see and visualize arrays.
...
Score quiz answers with key
This formula uses the named range key (C4:G4) for convenience only. Without the named range, you'll want to use an absolute reference so the formula can be copied.
In cell I7, we have this formula:
=SUM(--(C7:G7=key))
...Read more3 basic array formulas
Why use array formulas? In this video we'll look at three basic array formula examples. Traditional array formulas can solve tricky problems, and building array formulas in the dynamic array version of Excel is easier than ever...
Excel's RACON functions
There are eight widely used functions in Excel that use a syntax different from other functions in Excel. This syntax can make these functions more challenging to use, because it is not intuitive. Read on for important information about COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIF,...Read more
What is an array formula?
In this video, we'll answer the question: What is an array formula? The term "array formula" is probably responsible for more confusion than just about any other concept in Excel...
Sort text by length
The SORTBY function can sort values in a range with an array that doesn't exist on the worksheet.
In this example, we want to sort the values in B5:B15 by the number of characters each string contains. Working from...Read more
Convert time to money
Excel times are stored as fractional parts of one day. For example, 12 hours is equal to 0.5, and 18 hours is equal to 0.75. This means if you try to multiply an Excel time by an hourly rate, you'll get a total far less than expected.
The trick is to...Read more
Download Coronavirus data to Excel
This article provides examples of public Coronavirus data you can download to Excel with Power Query. Each example has a link, a screenshot to show what the data looks like in Excel after being imported, and an Excel workbook....Read more