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