Question: what is the difference between array formula and normal formula?
Answer: Essentially, an array in Excel is a collection of items. The items can be text or numbers and they can reside in a single row or column, or in multiple rows and columns. ... The difference between an array formula and regular Excel formulas is that an array formula processes several values instead of just one.