Ranking with TRUE or FALSE and without Skipping numbers (NO DUPLICATES)

[Masha92]

Hi everyone,

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>

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)>

 

[Masha92]

Yea i have been trying for 2 hours. Then i googled and everyone is talking about duplicate numbers! Then i did it with loops in VBA but got rejected... The cool thing about this formula that actually, i have a lot of other conditions, i just presented a sample for simplicity. So now it works with all my conditions and tested fine.