In other words, the same formula is located in two or more cells and returns different answers in each cell. Each copy or instance of the array formula performs the same calculation in each cell it is located in. But, because each instance of the formula uses different data in its calculations, each instance produces different results.
For More Information Please Refer:
You May Also Like to Read: