Can One Number Alternating Rows in Numbers

Hi Gene,

You can do this manually (a I suspect you did for the example).

You could also use a formula like one of those below.

Your description says you want to start with 1 in row 1, nothing in row 2, 2 in row 3, nothing in row 4…

Your screen shot shows an easier version, with 1 in row 2, 2 in row 4, and the rows between empty.

• Enter the formula on the left in A2, OR enter the formula on the right in cell A1
• Select the cell containing the formula AND the empty cell beneath it in column A.

Grab the Fill control (yellow dot) and drag down as many rows as needed.

Regards,

Barry

Here's one way I would do this:

In A2 I directly entered 1.

In A3 I entered this formula:

=IF(LEN(A2)=0,"",A2+1)

And filled that formula down the column by dragging the yellow dot.

Then select column A, command-c to copy, and Edit > Paste Formula Results, removing the formulas but leaving the numbers.

SG