It's probably extremely simple, but I'm having trouble making it work.

I need a formula that will automatically number rows based on the value in B1. I want to automatically number rows starting at 1 down to the value specified in B1 starting from column B1.

This must be a formula rather than using VBA due to additional technical challenges that it cannot overcome.

I succeed up until the defined value (blank), after which the subsequent row returns #VALUE due to the calculation's failure.

I have tried every combination of IF, IFS, >"", =, >=, AND, and OR that comes to mind.

What should I define in order to prevent the #VALUE error? The defined value in B1 will fall within the ranges of 6 and 48. Jan 20 in Others 65 views

## 1 answer to this question.

You can utilize SEQUENCE if you have Excel 365:

Put =SEQUENCE(B1,1,1,1) in the cell below Month

Because the values will flow down, there must be sufficient vacant cells below the formula cell.

This will produce a numbered sequence, where the number of rows is determined by a value in B1 and the first column is numbered 1.

• 59,740 points

## Spell number in excel 2013 using 2 rows

Hello, there are a few steps to ...READ MORE

## Excel - Make a graph that shows number of occurrences of each value in a column

There is probably a better way to ...READ MORE

## Calculate the number of days between a cell and today in excel?

Use the DATEDIF function when you want ...READ MORE

## MS Excel showing the formula in a cell instead of the resulting value

Make sure that... There's an = sign before the formula There's ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE