Function to Produce a Number Pattern?

[mommy2kh]

I'm not sure if this is possible, but do you have any thoughts on how to
produce a number pattern in Excel? I have numbers in a table like this:

1 2 3 4
5 6 7
8 9 10

I need to develop 4 or 5 different tables with the same numbers where each
number is with all the other numbers in the same row at least once. There
needs to be four columns. Is there a mathmatical way to do this? I
appreciate your help!

 

[Dave Curtis]

Hi,

You could try using a combination of the ROW() and COLUMN() functions to
generate the series that you want.

Dave

url:http://www.ureader.com/msg/104236314.aspx