In cell E2, again use the UNIQUE function, but this time, the array will be defined as FILTER(B2:B101, C2:C101 = “Active”). See the screenshot below for the formula and the results. Let’s use the ...

1. TODAY/NOW. There are 24 Date and Time functions listed on the drop-down menu under Formulas > Date & Time: 11 Date formats, 10 Time formats, and as many user-defined custom formats you can create.

Here’s an example of a basic Excel filter function formula, for example, filter how many employees stay in Florida (refer to the table): =FILTER(C5:E19, E5:E19=I1,"Florida") ...

They’re both useful, but you’ll use them in different circumstances. Figure D. Stay tuned. There are several new dynamic array functions and over the next few months, we’ll cover several of ...