excel formulas
how do i track 6000 raffle tickets in intervals of 10. There has to be a
formula rather than entering the numbers in manually! |
excel formulas
Type this into cell A1:
0001 - 0010 and then in A2 put this formula: =TEXT(LEFT(A1,4)+10,"0000")&" - "&TEXT(RIGHT(A1,4)+10,"0000") Copy this formula down the column until you reach 6000 - it will give you values like this: 0011 - 0020 0021 - 0030 0031 - 0040 0041 - 0050 Is this what you want? Hope this helps. Pete "lost in excel" wrote in message ... how do i track 6000 raffle tickets in intervals of 10. There has to be a formula rather than entering the numbers in manually! |
excel formulas
Another one:
Put this in a cell: =TEXT((ROW(A1)-1)*10+1,"0000")&" - "&TEXT(ROW(A1)*10,"0000") And drag down 600 rows Then select that range and convert it to values. (edit|copy followed by edit|paste special|values) lost in excel wrote: how do i track 6000 raffle tickets in intervals of 10. There has to be a formula rather than entering the numbers in manually! -- Dave Peterson |
excel formulas
Why the multi-post?
Gord Dibben MS Excel MVP On Wed, 19 Mar 2008 18:43:02 -0700, lost in excel wrote: how do i track 6000 raffle tickets in intervals of 10. There has to be a formula rather than entering the numbers in manually! |
All times are GMT +1. The time now is 10:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com