When you enter a dynamic array formula in one cell, Excel automatically populates the adjacent cells needed to display all the results. You’ll know it’s working when you see a blue border around this ...

Many businesses collect data for multifold purposes. Here's how to know what they're doing with your personal data and whether it is secure.