I recently started understanding array formulas a little better and wanted to explain in a visual way, because I would have loved to see something like this when I was trying to figure it out myself. Hopefully this helps someone.
This file is showing how to find the location of a given value. In this case, we are looking for the location of the largest number in a grid of numbers. I left the numbers as Randomly Generated between 1000 and 9999, so you can see how it works.
Each section contains the formula from the previous section, with modifications made and explained.
Feel free to modify any part of this to see what happens, make sure to use Control+ Shift + Enter to place the formulas after modifying.
Enjoy!
Bookmarks