Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a table with year 1, 2, and 3 across in columns and have 13 rows of
data that start at 1 and go to 4 in one-fourth increments. For example, row 1 is 1,1,1; row 2 is 1.25, 1.25, 1.25, row 3 is 1.50, 1.50, 1.50 all the way down to 4. I know that I have 1706 possible combinations (=permut(13,3). I need to know if there is a way to have EXCEL actually compute those combinations and show them on my spreadsheet. I need this for a project at work. Appreciate any help. -- Margie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
PERMUTATION AND COMBINATION | Excel Discussion (Misc queries) | |||
Permutation in excel | Excel Worksheet Functions | |||
Permutation in excel | Excel Worksheet Functions | |||
Permutation in excel | Excel Worksheet Functions | |||
Permutation Output | Excel Worksheet Functions |