View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Mike Sound
 
Posts: n/a
Default again: number a list

Hello there!
I found a thread "number a list" (June 2nd.2006):
I have an excel ss of book and video titles. I would like to make one
column
the number corresponding to each title. Just a simple scheme like 1, 2, 3,
4, 5, etc...
How would I tell excel to put sequential numbers in a column?

The problem was solved easy.

But what can I do when I have empty rows? I entered free rows for better
looking print result, unfortunately BEFORE fillseries.
Is there a formula, something like IF B10 fill A1?

Thanks for help!

Mike