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

[Masha92]

Hi everyone,

I am trying to rank data with conditions.

[TABLE="width: 192"]
<tbody>[TR]
[TD="width: 64, align: center"]TRUE[/TD]
[TD="class: xl67, width: 64, align: center"] TRUE[/TD]
[TD="width: 64, align: right"]5.46E+08[/TD]
[/TR]
[TR]
[TD="align: center"]TRUE[/TD]
[TD="class: xl67, align: center"] FALSE[/TD]
[TD="align: right"]31263409[/TD]
[/TR]
[TR]
[TD="align: center"]TRUE[/TD]
[TD="class: xl67, align: center"] TRUE[/TD]
[TD="align: right"]58662625[/TD]
[/TR]
[TR]
[TD="align: center"]TRUE[/TD]
[TD="class: xl67, align: center"] TRUE[/TD]
[TD="align: right"]2.36E+08[/TD]
[/TR]
[TR]
[TD="align: center"]FALSE[/TD]
[TD="class: xl67, align: center"] TRUE[/TD]
[TD="align: right"]23933559[/TD]
[/TR]
[TR]
[TD="align: center"]TRUE[/TD]
[TD="class: xl67, align: center"] TRUE[/TD]
[TD="align: right"]44886052[/TD]
[/TR]
</tbody>[/TABLE]

When i rank using sumproducts or countif... it skips numbers. so ideally i get,

[TABLE="width: 282"]
<tbody>[TR]
[TD="align: center"]TRUE[/TD]
[TD="align: center"] TRUE[/TD]
[TD="align: right"]545681153[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: center"]TRUE[/TD]
[TD="align: center"] TRUE[/TD]
[TD="align: right"]31263409[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: center"]TRUE[/TD]
[TD="align: center"] TRUE[/TD]
[TD="align: right"]58662625[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: center"]TRUE[/TD]
[TD="align: center"] FALSE[/TD]
[TD="align: right"]235698268[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="align: center"] TRUE[/TD]
[TD="align: center"] TRUE[/TD]
[TD="align: right"]23933559[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="align: center"]TRUE[/TD]
[TD="align: center"] FALSE[/TD]
[TD="align: right"]44886052[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
</tbody>[/TABLE]
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.