C
clamberti
I am trying to rank order data so that there are no ties.
If there is a tie in the score (column A) then Yes precedes No in column B.
If there is still a tie Yes precedes No in column C.
If there is still a tie rank order descending in column D.
If there is still a tie rank order descending in column E.
If there is still a tie rank order descending in column F.
If there is still a tie mark "Tie - rank #"
I cannot sort and filter as this is a very large spreadsheet and I need it
to do it automatically for someone who only knows how to enter data on Excel.
I have managed to rank and mark tie but not take into consideration other
columns with text.
=IF(COUNTIF($A$2:$A$300,A2)=1, RANK(A2,$A$2:$A$300), "Tie -
"&RANK(A2,$A$2:$A$300))
Any help would be greatly appreciated.
If there is a tie in the score (column A) then Yes precedes No in column B.
If there is still a tie Yes precedes No in column C.
If there is still a tie rank order descending in column D.
If there is still a tie rank order descending in column E.
If there is still a tie rank order descending in column F.
If there is still a tie mark "Tie - rank #"
I cannot sort and filter as this is a very large spreadsheet and I need it
to do it automatically for someone who only knows how to enter data on Excel.
I have managed to rank and mark tie but not take into consideration other
columns with text.
=IF(COUNTIF($A$2:$A$300,A2)=1, RANK(A2,$A$2:$A$300), "Tie -
"&RANK(A2,$A$2:$A$300))
Any help would be greatly appreciated.