ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can I create consecutivlely numbered tickets? (https://www.excelbanter.com/excel-worksheet-functions/8613-how-can-i-create-consecutivlely-numbered-tickets.html)

wheresleo

How can I create consecutivlely numbered tickets?
 
I am trying to make tickets using Excel. How do you create unique numbers per
cell like a commercially numbered ticket? Please Help!

Dave Peterson

If you put your seed number in A1, you could use:

=a1+1
in A2 and drag down.

and maybe in B1 (if you have multiple columns)
=max(a:a)+1
And drag down.

wheresleo wrote:

I am trying to make tickets using Excel. How do you create unique numbers per
cell like a commercially numbered ticket? Please Help!


--

Dave Peterson


All times are GMT +1. The time now is 12:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com