The difference is that an array formula processes several values instead of just one. What is the difference between Array Formula and Regular Excel Formula?
Our previous example of numbers 50, 2, 4, 3, 20, 9, 1, 51 is an array. Depending upon their nature we specify them as single-dimensional, two dimensional, and multidimensional. They can be in a single row or column, or in multiple rows and columns. The items can be text, numbers, both, or some special character. What is an Array?Īn Array is a collection of items. Array in Excel is an extremely powerful tool.Ī single Excel array formula can perform multiple calculations and replace thousands of usual formulas. In this case, you can’t use any of the above-mentioned processes.Īrray formulas can be utilized to solve the above case. You would have used the MAX() or LARGE() function or you would’ve manually searched the data to find out the two largest number and then used SUM() function.īut for instance, you have a huge dataset containing thousands of numbers and you are asked to total the top 100 largest values. Most probably your answer would be 51+50 =101.
You are asked to find out the two largest value and their total from the following number:- 50, 2, 4, 3, 20, 9, 1, 51. You might have a few questions like What is an array? Why should I learn about Array in Microsoft Excel? And most important, what is the use of an array? In this post, we will examine the topic array formulas which is an important topic in Excel.