Generate a special numerical sequence in Excel 97

  • Thread starter Thread starter PSRumbagh
  • Start date Start date
P

PSRumbagh

I want to automatically generate the following recursive numerical sequence
in a column (e.g., column "A"): a1=0, a2=9, a3=10, a4=19, a5=20, a6=29,
a7=30, a8=39, a9=40, a10=49, a11=50 ... etc up to about a2000. I have not
been able to figure out a formula to use with click and drag.
 
I tried this before without any luck. I forgot to use the "shift key" along
with the left mouse button to select the pair of cells to drag. Thanks,
everything works OK now.
 
:-)

Glad it worked out...

PSRumbagh said:
I tried this before without any luck. I forgot to use the "shift key" along
with the left mouse button to select the pair of cells to drag. Thanks,
everything works OK now.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to use an formula to transpose a list(left) to be like the right? 2
Return next non-Blank Cell in a Column ? 4
Maximum Number of Blank Cells between Non Blank Cells in a Range 5
enter numbers in blank cells 2
Remove specific cells in a column. 2
excel formula 2
Bug in Excel? 2
How to delete ALL cells containing the same data 1

Back
Top