Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
Copying formulas from Excel 2003 to Excel 2007 | Excel Discussion (Misc queries) | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
3D formulas in Excel | Excel Worksheet Functions | |||
Excel formulas | Excel Worksheet Functions |