Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
setting up sequence sets with only 3 repeat once in excel
I have a return data of 12 23 24 25 26 29 31 33 34 43 (example only, the data is much bigger). I need to set up sequence sets of 5 numbers in each set. The sequence sets are very big so I only want 3 number repeat only once in one set, once a sequence has 3 exact number it needs to move to the next sequence. For example:
12 23 24 25 26 12 23 24 29 31 (NO! 3 numbers repeat already on the previous set) I don't even know how to begin the formula for the Excel 2007. Please help. thank you very much!!! EggHeadCafe - Software Developer Portal of Choice VB : Numeric to Word converter http://www.eggheadcafe.com/tutorials...word-conv.aspx |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
setting up sequence sets with only 3 repeat once in excel
It would really help if you'd also tell us what the correct results you
expect from this sequence are. Also, tell us if your return data is all in a column, or in a row. Finally, tell us how the sets of 5 are to be displayed (on rows, in columns, ??) Assuming that your return set is in column A beginning on row 1, you can return the set broken up into 5 number sets in other columns this way. This example starts the first group in column C, row 1 in cell C1 enter this formula: =OFFSET($A1,(COLUMN()-COLUMN($C$1))*5,0) extend/fill it down to row 5. Then select C1:C5 and fill it to the right into columns D, E, F, etc. for as far as it needs to go to pick up all the numbers in the list in column A. If that formula/solution doesn't work, we definitely need the information I asked for in the first paragraph. "sierra" wrote: I have a return data of 12 23 24 25 26 29 31 33 34 43 (example only, the data is much bigger). I need to set up sequence sets of 5 numbers in each set. The sequence sets are very big so I only want 3 number repeat only once in one set, once a sequence has 3 exact number it needs to move to the next sequence. For example: 12 23 24 25 26 12 23 24 29 31 (NO! 3 numbers repeat already on the previous set) I don't even know how to begin the formula for the Excel 2007. Please help. thank you very much!!! EggHeadCafe - Software Developer Portal of Choice VB : Numeric to Word converter http://www.eggheadcafe.com/tutorials...word-conv.aspx . |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
It would really help if you would also tell us what the correct results- JLatham
Nope, the formula didn't works. The values are layout across (not down): 3 4 6 7 8...
And the answer or result sequence set needs to be across also: 3 4 6 7 8 thanks JLatham wrote: It would really help if you would also tell us what the correct results 22-Oct-09 It would really help if you would also tell us what the correct results you expect from this sequence are. Also, tell us if your return data is all in a column, or in a row. Finally, tell us how the sets of 5 are to be displayed (on rows, in columns, ??) Assuming that your return set is in column A beginning on row 1, you can return the set broken up into 5 number sets in other columns this way. This example starts the first group in column C, row 1 in cell C1 enter this formula: =OFFSET($A1,(COLUMN()-COLUMN($C$1))*5,0) extend/fill it down to row 5. Then select C1:C5 and fill it to the right into columns D, E, F, etc. for as far as it needs to go to pick up all the numbers in the list in column A. If that formula/solution does not work, we definitely need the information I asked for in the first paragraph. "sierra" wrote: Previous Posts In This Thread: EggHeadCafe - Software Developer Portal of Choice Design Pattern Interview Questions Part 3 http://www.eggheadcafe.com/tutorials...interview.aspx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Enter Key Sequence? | Excel Discussion (Misc queries) | |||
Excel graph 3 sets of data. 2 sets as lines 1 as column? | Charts and Charting in Excel | |||
Setting different rows to repeat for print. | Excel Discussion (Misc queries) | |||
Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec | Excel Discussion (Misc queries) | |||
How do I use excel to add up the best 5 numbers in a sequence? | New Users to Excel |