Hi All
I hope someone can help I have a column with lots of data in it (I have attached a small portion in the workbook) I need to rank every six entries going down the column. I have googled and found the + countif option to break the ties but I cant seem to get it to work?
I hope someone can point me in the right direction.
Thanks
<colgroup><col width="64" style="width:48pt" span="2"> <col width="64" style="width:48pt"> </colgroup><tbody>
</tbody><strike></strike>
I hope someone can help I have a column with lots of data in it (I have attached a small portion in the workbook) I need to rank every six entries going down the column. I have googled and found the + countif option to break the ties but I cant seem to get it to work?
I hope someone can point me in the right direction.
Thanks
3 | 28.6 | |
6 | 80.02 | |
1 | 20.07 | |
4 | 35.01 | |
5 | 43.61 | |
2 | 24.34 | |
4 | 40.28 | |
1 | 20.71 | |
5 | 50.05 | |
1 | 20.71 | |
3 | 30.48 | |
6 | 69.57 | |
6 | 68.38 | |
3 | 51.33 | |
5 | 63.57 | |
3 | 51.33 | |
2 | 23.82 | |
1 | 21.66 |
<colgroup><col width="64" style="width:48pt" span="2"> <col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>