rank testscores

  1. 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...
  2. 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"...
  3. 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...
  4. 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

Some videos you may like

This Week's Hot Topics