Hello,
I have a table of data that I'd like some help with creating a formula that ranking within each year, depending on if the number is higher or lower than a certain value. Below is an example of the table:
<tbody>
</tbody>
The values associated with D will be my baseline for determining if the other numbers within the same year are higher or lower. Anything higher than 5 in 2013 would go above (in this example, there are none) and anything lower would go below the 5. An example of the output for 2013 would look like this:
<tbody>
</tbody>
I'm fine with getting my baseline D values in, but struggling to create a formula that looks at the table and ranks if higher or lower, and ignores my baseline. Any suggestions?
I have a table of data that I'd like some help with creating a formula that ranking within each year, depending on if the number is higher or lower than a certain value. Below is an example of the table:
2013 | 2014 | 2015 | 2016 | |
A | 3 | 6 | 5 | 0 |
B | -2 | 5 | -4 | 6 |
C | -4 | 4 | -2 | 8 |
D | 5 | -9 | 4 | 2 |
E | 1 | 1 | 7 | 4 |
<tbody>
</tbody>
The values associated with D will be my baseline for determining if the other numbers within the same year are higher or lower. Anything higher than 5 in 2013 would go above (in this example, there are none) and anything lower would go below the 5. An example of the output for 2013 would look like this:
2013 |
5 |
3 |
1 |
-2 |
-4 |
<tbody>
</tbody>
I'm fine with getting my baseline D values in, but struggling to create a formula that looks at the table and ranks if higher or lower, and ignores my baseline. Any suggestions?