|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 9th, 2010, 09:23 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
duplicate numbers being given different rankings
Have list of percentages which have been sourced from another sheet within an
excel document - when i rank these some duplicates are given the same ranking and some are given different rankings eg. 2 results of 6.16% were both ranked 13 while 2 results of 6.11% were ranked 10 & 11 
|
|
#2
February 9th, 2010, 10:36 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
duplicate numbers being given different rankings
Increase the number of decimals to see whether the cells contents are exactly
same or is rounded off and displayed as 6.11 -- Jacob "Mantis" wrote: Have list of percentages which have been sourced from another sheet within an excel document - when i rank these some duplicates are given the same ranking and some are given different rankings eg. 2 results of 6.16% were both ranked 13 while 2 results of 6.11% were ranked 10 & 11
|
|
#3
February 9th, 2010, 02:30 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
duplicate numbers being given different rankings
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
