Thread
:
Auto Fill Series when number ends in -1
View Single Post
#
5
Posted to microsoft.public.excel.misc
Ken Johnson
Posts: n/a
Auto Fill Series when number ends in -1
Hi JGus,
Alternatively if starting in C10:
=900000823+ROW()-ROW(C$9) &"-1"
to keep the starting figure 900000823 consistent, avoiding confusion.
Ken Johnson
Reply With Quote
Auto Fill Series when number ends in -1