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 ...

What is the most important thing to look for in real estate? There's a bit more to it than just location, location, location. Here are some other factors.