View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mommy2kh mommy2kh is offline
external usenet poster
 
Posts: 9
Default Function to Produce a Number Pattern?

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!