Hi everyone,
I am trying to rank data with conditions.
<tbody>
</tbody>
When i rank using sumproducts or countif... it skips numbers. so ideally i get,
<tbody>
</tbody>My formula is
<u$3:u$8) countif(u$3:u$8,u$3:u$8&""))+1)<u$3:u$8)="" countif(u$3:u$8,u$3:u$8&""))+1)
<u>IF (AND(T3,S3), SUMPRODUCT((U3<U$3:U$8) / COUNTIF (U$3:U$8,U$3:U$8&"")) +1)</u>
<u$3:u$8) countif(u$3:u$8,u$3:u$8&""))+1)
Any help on this? I cannot afford skipping numbers. I.e Number 3 in the previous example should be 2.
Thanks,
Masha</u$3:u$8)></u$3:u$8)>
I am trying to rank data with conditions.
TRUE | TRUE | 5.46E+08 |
TRUE | FALSE | 31263409 |
TRUE | TRUE | 58662625 |
TRUE | TRUE | 2.36E+08 |
FALSE | TRUE | 23933559 |
TRUE | TRUE | 44886052 |
<tbody>
</tbody>
When i rank using sumproducts or countif... it skips numbers. so ideally i get,
TRUE | TRUE | 545681153 | 1 |
TRUE | TRUE | 31263409 | 5 |
TRUE | TRUE | 58662625 | 3 |
TRUE | FALSE | 235698268 | FALSE |
TRUE | TRUE | 23933559 | 6 |
TRUE | FALSE | 44886052 | FALSE |
<tbody>
</tbody>
<u$3:u$8) countif(u$3:u$8,u$3:u$8&""))+1)<u$3:u$8)="" countif(u$3:u$8,u$3:u$8&""))+1)
<u>IF (AND(T3,S3), SUMPRODUCT((U3<U$3:U$8) / COUNTIF (U$3:U$8,U$3:U$8&"")) +1)</u>
<u$3:u$8) countif(u$3:u$8,u$3:u$8&""))+1)
Any help on this? I cannot afford skipping numbers. I.e Number 3 in the previous example should be 2.
Thanks,
Masha</u$3:u$8)></u$3:u$8)>
Last edited: