So, in your system, a branch with 1 1 1 3 would rank below a branch
with 2 2 2 2 ? How about a branch with 1 1 1 4, that would rank
below a branch with 3 3 3 3 ?
Maybe you should just add them up and rank by the lowest scores.

"meral" wrote:


Branch U1 U2 U3 U4
a 1 2 2 4
b 2 1 3 2
c 3 4 1 3
d 4 3 5 1
e 5 5 4 5

Hello all here is my table lets explain first!!!

My table show through A1-E6 in excell table, branch names a,b,c...
u1,u2... are criterias that i use.....and ranks in each criterias...
My question is how can i find a branch that is the best with all
criteria...
And rank all branches sequentially....
Branch should be the best with all criteria...First look is it first in
all criteria?
No there is no branch...
Then look 1. and 2. is there any branch 1.or 2. in all criteria??no...
Then look 1.2.3. is there any branch 1.2. or 3. in all criteria???Yeahh
branch b
Ok branch b is my first branch...then abstract branch b from table then
look with the same procedure for the best 2. branch or branches...
I hope explained all... ask any question...thanx from now..




--
meral
------------------------------------------------------------------------
meral's Profile: http://www.excelforum.com/member.php...fo&userid=7357
View this thread: http://www.excelforum.com/showthread...hreadid=496385