L lost in excel Mar 20, 2008 #1 how do i track 6000 raffle tickets in intervals of 10. There has to be a formula rather than entering the numbers in manually!
how do i track 6000 raffle tickets in intervals of 10. There has to be a formula rather than entering the numbers in manually!
P Pete_UK Mar 20, 2008 #2 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
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
D Dave Peterson Mar 20, 2008 #3 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)
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)
