| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pareto With Excel
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
| VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
| Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
| Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Threaded Mode
