| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function to Produce a Number Pattern?
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Any formula to count number of cells with a specific color pattern | Excel Worksheet Functions | |||
| How do I produce organigrams in Excel? | Excel Discussion (Misc queries) | |||
| Why MS Excel produce diffrent result for the function "Quartile" | Excel Worksheet Functions | |||
| How do I produce a number in parentheses? | Excel Discussion (Misc queries) | |||
| produce a formulate to produce assigned seats for dinner | Excel Worksheet Functions | |||
Linear Mode
