Auto Numbering
 

I am using the Office 200 suite and have created an Invoice, however I am
unable to create auto numbering in the invoice - I have tried to do it but
have failed. I have read most of the posts on this forum but it is not
helping me at all. I have only a very basic knowledge on the PC an in Excel
work sheet etc.
If anybody can give me an idiots guide to how to create auto numbering it
would be most greatful.

Thanks
Andy

Auto Numbering
 

If the column you want the number in is A and the Column your data is in
is B put this formula in A. Then copy and paste it the the end of the
range you want numbered.
=COUNTIF($B$1:$B1,"""")

If there will be empty rows use this formula. It will cause the
numbering to skip any empty cells in column B.

=IF(B9"",COUNTIF($B$9:$B9,""""),"")

Hope it helps.


--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=484668

Auto Numbering
 

Goober,
Thank you for that but I dont think it's what I'm after. What I have done is
made an invoice templete, then opened excel workwheet in it, consisting of
column A & B and 2 rows.Row A is A1= the word "DATE" B1= input actual date.
A2 the Word Invoice N0. then in B2 = I want to but a numer i.e 0001- then
next time I open the Invoice templete the Invoice Number will automatically
be 0002- etc etc.
An idiots step by step guide on how to do this would be most helpful.

Thanks #
Andy


"goober" wrote:


If the column you want the number in is A and the Column your data is in
is B put this formula in A. Then copy and paste it the the end of the
range you want numbered.
=COUNTIF($B$1:$B1,"""")

If there will be empty rows use this formula. It will cause the
numbering to skip any empty cells in column B.

=IF(B9"",COUNTIF($B$9:$B9,""""),"")

Hope it helps.


--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=484668

Auto Numbering
 

Hi Andy,
see
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Andy JL" <Andy wrote in message ...
I am using the Office 200 suite and have created an Invoice, however I am
unable to create auto numbering in the invoice - I have tried to do it but
have failed. I have read most of the posts on this forum but it is not
helping me at all. I have only a very basic knowledge on the PC an in Excel
work sheet etc.
If anybody can give me an idiots guide to how to create auto numbering it
would be most greatful.

Thanks
Andy