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, 2023 in Others 361 views

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.

• 63,720 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