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

I think we need a little more detail
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"OMER" wrote in message
...
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).


"Bernard Liengme" wrote:

I think we need a little more detail
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"OMER" wrote in message
...
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

.

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


"OMER" wrote in message
...
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).


"Bernard Liengme" wrote:

I think we need a little more detail
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"OMER" wrote in message
...
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

.

Thak you Mike, it worked. I thought I needed some special library but Excel
has it already.

"Mike Middleton" wrote:

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


"OMER" wrote in message
...
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).


"Bernard Liengme" wrote:

I think we need a little more detail
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"OMER" wrote in message
...
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

.

.