| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I prevent tied results when ranking data?
When I use rank to identify the Top 50, I sometimes get a tie, I would like
to be able to always have a rank of 1,2,3,4,etc even if the standard rank function generated 1,2,2,4 (i.e. although the data has actually got 2 equal values, I would like to distinguish them, by having one ranked at 2 and one ranked at 3. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with data not getting plotted | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
| Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) | |||
Threaded Mode
