How to Create an Array of Numbers in Excel Office 365?

In this post, we will assist you to know the different ways to Create an Array of Numbers in Excel Office 365 with practical examples. To do this, we will use the combinations of Excel functions such as the ROW Function, INDIRECT function, the INDEX function, or MIN function. Let’s get into this post and learn how to achieve it. Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Four Ways to Create an Array of Numbers:

Try the following ways to create an array of numbers in your worksheet.

Example 1:

• To create an array like {1;2;3;4;5} , you can use the following formula.

=ROW(B1:B5)-MIN(ROW(B1:B5))+1

• You need to enter the formula and hit the Enter key to get the result.

Example 2:

• You can also use the below-given formula to insert an array in your worksheet.

=ROW(INDIRECT(“1:6”))

• Apply the formula and press the Enter key to get the result.

Example 3:

• To insert an array in your worksheet, you can also use an INDEX function.
• Refer to the below formula.

=ROW(INDEX(A:A,1):INDEX(A:A,5))

• Type the formula in any cell and hit the Enter key to get the output as shown in the below image.

Example 4:

• The simple Row function will be used to create array elements in Excel.
• You can use the below formula.

=ROW(B1:B5)

• After entering the formula into a single cell, you have to press the Enter key to get the output.

Closure:

In this useful post, we have learned the different ways to Create an Array of Numbers in Excel Office 365 with practical examples. Kindly, leave your suggestions/feedback in the below comment section. To learn more, check out our website *Geek Excel!! *

Read Also:

• Remove Non-numeric Characters from a Cell in Excel
• Split Text String by Line Break in Excel Office 365
• Get the Current Worksheet Name Only in Excel