NUMBERING ROWS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi, i am trying to give the rows a number in a designated column that when 1
is entered and i drag down the rows the numbers following will automatically
change in order eg 1.2.3.4.5.6.7.8.9. etc

any help willbe brilliant

thanks
 
One guess ..

Suppose the initial row number will be entered in A1, eg in A1: 1
Put in A2: =IF($A$1="","",A1+1)
Copy A2 down as far as required
 
You must log in or register to reply here.

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

Excel Help to copy information from one row at a time to another sheet 1
numbering 1
Match and delete rows on two different sheets from reference numbers 4
using row number or column letters in formula 5
complex sort search and replace macro 2
hidden rows problem 7
Is there an Excel formula to show the highest letter in a row? 8
Why Excel Does not increment by 2 or 3, odd/even numbers? 6

Back
Top