How to insert a number sequence in irregular rows or columns of Excel - just as 'Listnum' field woul

A

av

Hi,

I cannot find in the Help files of my Excel '97 how to insert, in
effect, a field which would increase by one every time I copy it
into a different cell. I only know how to insert such a series
over a contiguous set of rows or columns using the Edit>Series
menu.

Does anyone here please have an answer to this problem? Or is
there one??

Thank you for taking the trouble to read this enquiry.

avril
 
D

Debra Dalgleish

To create sequential numbers in column A, enter the following formula in
cell A2:

=MAX($A$1:A1)+1

Copy this formula to another cell in column A, to create the next number.
 
A

av

Debra Dalgleish said:
To create sequential numbers in column A, enter the following formula in
cell A2:

=MAX($A$1:A1)+1

Copy this formula to another cell in column A, to create the next number.
Click to expand...
series

Thank you Debra. I will certainly use that.
avril
 
Top