Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Matrix
I have a matrix, lets say 10 down and 10 across. I want to be able to type
lets say one through 10 in one cell from the column, and then one through 10 in another cell from the across column, and I want the 3rd cell to give me the intersection of those two cells.. So for example, the matrix looks like this.. 1 2 3 1 5 10 5 2 7 8 9 3 4 3 2 and when I type 2 in the first cell and 3 in the next cell I want the result to be 9! Thank you all for helping me.. Eyad |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Recreate the upper part of a symetric data matrix 75x75 | Excel Discussion (Misc queries) | |||
CORRELATION / COVARIANCE MATRIX | Excel Worksheet Functions | |||
Correlation matrix | Excel Worksheet Functions | |||
Finding Values in a "Matrix" | Excel Discussion (Misc queries) | |||
entering matrix formula | Excel Worksheet Functions |