One way:

Select A1:A16xxx. Enter this in the formula bar using CTRL-Enter

=INT((ROW()+1)/2)

In article ,
childofthe1980s wrote:

Hello:

I have a spreadsheet, and I need to number each set of two rows throughout
the spreadsheet.

For example, the first two rows need to be numbered 1, the second two rows
need to be numbered 2, the third two rows need to be numbered 3, and so forth.

This spreadsheet has over 16,000 rows. Is there a quick way of doing this?

Thanks!

childofthe1980s