| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing ranking
I have 3 cols of data,at the moment H,N AND W. JOHN 1 3.25 JOHN 2 8 JOHN 3 6 JOHN 4 2.75 JOHN 5 11 JOHN 6 15 MARY 1 8 MARY 2 5 MARY 3 5 MARY 4 2.75 MARY 5 11 MARY 6 17 MARY 7 13 N is the actual ranking. W is the predicted results,unranked. Lowest is best in the predicted results,thus 2.75 is ranked 1st,3.25 is ranked 2nd etc. I want to produce another column which will show the numerical difference between the actual ranking and the predicted ranking,the first row will be 1 -2 =-1. I also want to show for each person in another extra column ,the percentage of the total below each number in the predicted column. Thus 3.25 finished first, 5 out of 6 are below,so show 83%,on the second row 4/6 =67%. -- pytelium ------------------------------------------------------------------------ pytelium's Profile: http://www.excelforum.com/member.php...o&userid=25521 View this thread: http://www.excelforum.com/showthread...hreadid=497999 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing two spreadsheets | Excel Worksheet Functions | |||
| Ignore Non-Alphanumerics When Comparing Text | Excel Worksheet Functions | |||
| Comparing two lists in excel that don't match exactly | Excel Worksheet Functions | |||
| Ranking Using Grand Total | Excel Discussion (Misc queries) | |||
| Comparing Data in two columns | Excel Worksheet Functions | |||
Threaded Mode
