Pairwise comparison using excel

  • Thread starter Thread starter OMER
  • Start date Start date
O

OMER

I need some advice/reference on how to implement pairwise comparison using
Excel. The idea is to be able to write code to compare a set of priorities
against each other and find relateive weights.
Thanks in advance.
OMER
 
Sorry for not explain myself correctly. I'm trying to perform an algebraic
operation.
What I need is to wirte code to multiple a matrix (located on range C5:G9)
by itself. In other words, Matrix ^ 2 (matrix exp 2).
 
OMER -

For in-place squaring of each element, select the range, copy, paste special
multiply.

For a matrix multiplication operation, in some other range, use the
array-entered MMULT function. That is, select a 5x5 range, type
=MMULT(C5:G9,C5:G9) but don't press Enter, instead hold down the Ctrl and
Shift keys while you press Enter.

- Mike
http://www.MikeMiddleton.com
 
Thak you Mike, it worked. I thought I needed some special library but Excel
has it already.
 
Back
Top