-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
rank testscores
-
B
RANK Solution needed please :)
Hello All, Im sure you will be able able to help with the following question: I am trying to RANK a list of data but where the number maybe the same how can i get the formula to not have duplicates... So far example below i want James to be ranked 4th and Sally 5th even though they both had...- Bennets04
- Thread
- rank rank testscores rank unique ranking data
- Replies: 8
- Forum: Excel Questions
-
D
Rank within a group & within a sub-group problem
Using Excel 2010, RANK.EQ works fine for showing a rank within a range. However I also want to work out the rank within a sub-group of the range based on a condition. I can't figure out how to do this, any ideas? The table below shows what I am after: Excel 2010<table rules="all"...- dleseward
- Thread
- rank testscores ranq.eq
- Replies: 15
- Forum: Excel Questions
-
A
How to allocate data based on preferences and ranks
<table style="border-collapse: collapse; width: 403pt;" border="0" cellpadding="0" cellspacing="0" width="535"><col style="width: 22pt;" width="29"> <col style="width: 33pt;" width="44"> <col style="width: 34pt;" span="6" width="45"> <col style="width: 48pt;" span="3" width="64"> <tbody><tr...- amarkant.jain
- Thread
- allocation based on ranks rank rank testscores
- Replies: 3
- Forum: Excel Questions
-
S
Rank test scores, in descening order but, omitt values below a specified cut-off point
Hello, I need to run a macro to rank test scores in descending order but I would like to omitt values below a specific value, so that those who do not make the cut-off are listed as zero and those who do are included on the rank- similoluwa
- Thread
- rank testscores
- Replies: 3
- Forum: Excel Questions
