| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matrix in cells
Hi,
Is there a way to obtain a matrix in a cell ? A B C 1 1 5 9 2 2 6 10 3 3 7 11 One way (that doesn't work ....) formula in D1 {= A1:C3} that display as result: 1 (contain in A1) And my goal is to have in E1 the result: 10 with a formula in E1 like =index(D1;2;3) Thanks Gilles P |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
| how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
| requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
| Finding Values in a "Matrix" | Excel Discussion (Misc queries) | |||
Threaded Mode
