incrementing every two rows
Interesting solution from JE again........
Keep forgetting about the CNTRL-ENTER
Of course you would after that do the <edit<copy<paste<paste
special<values thing to convert the
formula's to values.
One other way would be to extend a simple 1,2,3 range to 8xxx (i.e. halfway)
copy that and paste it into the second half and finish with a sort.
You may have to do this on a empty sheet and copy the result across.
--
Greetings from New Zealand
Bill K
"JE McGimpsey" wrote in message
...
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
|