Spreadsheet: 874501d1721115816-ranking-on-cell-value-and-getting-number-of-unique-value-error-zero-rank
Sheet: Sheet1

 | @windknife | @Ali |  |  | @windknife | @Ali |  |  | @windknife | @Ali |  |  | @windknife | @Ali |  |  | @windknife | @Ali
1.067781470724332 |  |  |  | 4.440769562164561 |  |  |  | 3.244319863589726 |  |  |  | 4.434817129773552 |  |  |  | 1.068429019527637
0.713702311622566 |  |  |  | 4.819617475550621 |  |  |  | 11.95 |  |  |  | 2.078161696900342 |  |  |  | 5.939440469235955
0.5728957493224205 |  |  |  | 1.470699737708617 |  |  |  | 3.578084653826903 |  |  |  | 11.95 |  |  |  | 5.038361948499896
0.1447384814358656 |  |  |  | 1.688197247205802 |  |  |  | 7.213231100025085 |  |  |  | 8.07007767279081 |  |  |  | 1.535524650309366
0.2643149749874298 |  |  |  | 1.195514099447682 |  |  |  | 3.5 |  |  |  | 3.725 |  |  |  | 1.503342313586634
0.4140492834040109 |  |  |  | 0.623850125460868 |  |  |  | -0.115542584634701 |  |  |  | 1.2 |  |  |  | 6.688753090000904
0.3924897489015126 |  |  |  | -0.6250000000000004 |  |  |  | 1.2 |  |  |  | 3.35 |  |  |  | 8.975
0.03963387111831045 |  |  |  | 2.020005057426894 |  |  |  | 3.35 |  |  |  | -0.1290176108941714 |  |  |  | 5.55
-0.006946952496223649 |  |  |  | 1.2 |  |  |  | 3.725 |  |  |  | -0.1610937987512735 |  |  |  | -0.1496504917355345
0.2609876258204319 |  |  |  | -3.605075243064711 |  |  |  | 5.283159434271427 |  |  |  | 5.652942562884052 |  |  |  | 2.669203591574875
0.08602513501641959 |  |  |  | 0.9993852198318889 |  |  |  | 0.778251171287112 |  |  |  | 3.992911747769921 |  |  |  | 2.421566785846715
0.15299674340942 |  |  |  | 0.6252980468109797 |  |  |  | 18.5 |  |  |  | 1.949493374107869 |  |  |  | 11.95
0.2514702690598318 |  |  |  | 0.4436866308706628 |  |  |  | 12.425 |  |  |  | 1.531596565524273 |  |  |  | 4.5
0.3731911995780862 |  |  |  | -0.08771702740210545 |  |  |  | 11.04841179298176 |  |  |  | 2.614777452209976 |  |  |  | 3.605004132812844
0.2614974850184024 |  |  |  | 7.89036560310976 |  |  |  | 6.258644356956946 |  |  |  | 4.113545745465065 |  |  |  | 0.7450898663407212
0.3348462920412394 |  |  |  | 5.039200402825869 |  |  |  | 7.949999999999999 |  |  |  | 1.910229684435235 |  |  |  | 5.912275609010033
0.2476629567969271 |  |  |  | 3.493323106011208 |  |  |  | -1.578473976484164 |  |  |  | 7.275 |  |  |  | 1.273050525058953
0.2469459295303718 |  |  |  | 1.074555036659353 |  |  |  | 17.65 |  |  |  | 3.034043567239616 |  |  |  | 3.637091153287318
0.1005426830715472 |  |  |  | 3.012939991606526 |  |  |  | 7.141492807803966 |  |  |  | 6.005434227380569 |  |  |  | 5.174999999999999
0.1510858467659267 |  |  |  | 4.967954992690249 |  |  |  | 2.978961537169005 |  |  |  | 0.04024982313386717 |  |  |  | 0.669119232100607
-0.09263643549498113 |  |  |  | 3.312231805846152 |  |  |  | 1.282613831141997 |  |  |  | 5.824305424153821 |  |  |  | -0.3164081751842632
0.1709413801031829 |  |  |  | 1.079972537809179 |  |  |  | 3.572310613456712 |  |  |  | 3.291999792703827 |  |  |  | 7.312273640704078
0.214225478468337 |  |  |  | -1.988602215808769 |  |  |  | 10.675 |  |  |  | 6.631598206008189 |  |  |  | 3.440050038513044
0.01907853224042115 |  |  |  | 15.275 |  |  |  | 0.08339407078647207 |  |  |  | 2.26563943947818 |  |  |  | 10.675
0.1986107902572418 |  |  |  | 11.15 |  |  |  | 7.275 |  |  |  | 1.803870344159219 |  |  |  | 7.255441085974833
0.2418392244085373 |  |  |  | 1.145912877938893 |  |  |  | -2.92858982193072 |  |  |  | 1.553883415812976 |  |  |  | -1.208476655122007
0.1047653116939808 |  |  |  | 1.36902327041384 |  |  |  | 8.782484292320493 |  |  |  | -1.077436634902606 |  |  |  | 6.745346034746711
0.004558786408296384 |  |  |  | 3.489717220204533 |  |  |  | 7.029759094417956 |  |  |  | 1.695063086949389 |  |  |  | 17.975
0.1781034279582717 |  |  |  | 3.556696128005639 |  |  |  | 5.174999999999999 |  |  |  | 2.896951074316926 |  |  |  | 10.29741743204876
0.2871879447462358 |  |  |  | -0.6629793805670556 |  |  |  | 3.27046859941531 |  |  |  | 2.723253521403233 |  |  |  | 1.675836788016579
0.1418724472245706 |  |  |  | 8.675 |  |  |  | 1.296619063529241 |  |  |  | 10.90653939894339 |  |  |  | 2.211825597290108
0.1743488387201977 |  |  |  | -0.9299793141996565 |  |  |  | 5.256092204652392 |  |  |  | 2.838060507685578 |  |  |  | 4.05657824815744
0.1583920191286728 |  |  |  | 4.446244015027141 |  |  |  | -0.6117885109635229 |  |  |  | 2.752927065636884 |  |  |  | 7.454239440557064
0.1096442066021531 |  |  |  | 13.15 |  |  |  | 9.986058241434542 |  |  |  | 0.5512777105464349 |  |  |  | -5.275
-0.2034197063808156 |  |  |  | -0.3672153116132548 |  |  |  | 3.377480206084013 |  |  |  | -1.114374243427561 |  |  |  | -2.795492940371072
0.1637294392565637 |  |  |  | 0.004160145530956264 |  |  |  | 4.415230520615735 |  |  |  | 4.487891906176785 |  |  |  | 4.687316875028463
0.1694408196782713 |  |  |  | 0.05706326615196845 |  |  |  | 2.931658112269086 |  |  |  | 17.65 |  |  |  | -0.7661681818756358
0.2092779368180969 |  |  |  | -10.075 |  |  |  | 4.294395197562524 |  |  |  | 7.464581898937832 |  |  |  | 1.430400551946023
0.05616961707962195 |  |  |  | 18.725 |  |  |  | 1.200575873047171 |  |  |  | -1.357265403020778 |  |  |  | 3.808048957832093
0.1651081933285159 |  |  |  | 1.438701108687323 |  |  |  | -0.7169538958768529 |  |  |  | 10.675 |  |  |  | 6.582676223542029
0.1466535201430702 |  |  |  | 0.4038111478417713 |  |  |  | 1.511770952493961 |  |  |  | 2.830770236755629 |  |  |  | 7.39199868846052
0.03717385681909687 |  |  |  | 0.7470760274176719 |  |  |  | 13.6 |  |  |  | 2.648889254211724 |  |  |  | 5.699999999999999
-0.1085638846614029 |  |  |  | -2.09335291209755 |  |  |  | 1.790067252251924 |  |  |  | 2.610935217002225 |  |  |  | 2.84786429533754
0.1832103655053214 |  |  |  | 4.649999999999999 |  |  |  | 1.173791385302948 |  |  |  | -1.543227901683631 |  |  |  | 2.726097212901442
0.1379335534636748 |  |  |  | 6.975 |  |  |  | -5.514091208027376 |  |  |  | 6.019771798785706 |  |  |  | 2.567266445470062
-0.1039942463729774 |  |  |  | 5.975000000000001 |  |  |  | 4.653049709695976 |  |  |  | -2.585881177657115 |  |  |  | 3.336385912208897
0.06182091972558531 |  |  |  |  |  |  |  | 2.07214570336521 |  |  |  | 2.789343957488838 |  |  |  | 1.556923268922967
0.09003335447102474 |  |  |  |  |  |  |  | 3.343178880637501 |  |  |  | -0.7544530879901832 |  |  |  | 2.642088389654639
0.0774641493920744 |  |  |  |  |  |  |  | -0.425745541056159 |  |  |  | 2.50982262752635 |  |  |  | 12.15
-0.04987801746652681 |  |  |  |  |  |  |  | 1.998919518077294 |  |  |  | 2.608065267192309 |  |  |  | 2.034280320012043
0.06545249057144141 |  |  |  |  |  |  |  | -10.175 |  |  |  | 13.6 |  |  |  | 0.7774761595718459
0.03732258100238346 |  |  |  |  |  |  |  | 8.65 |  |  |  | -0.6780033125637972 |  |  |  | 2.585809746753561
0.007400158481569725 |  |  |  |  |  |  |  | 0.5714052124509723 |  |  |  | 3.145382926699597 |  |  |  | 2.304419710713268
 |  |  |  |  |  |  |  | 2.29940310761258 |  |  |  | 13.75 |  |  |  | 3.046506941646236
 |  |  |  |  |  |  |  |  |  |  |  | -10.175 |  |  |  | 1.63406598760554
 |  |  |  |  |  |  |  |  |  |  |  | -0.4282035095040495 |  |  |  | 1.649076737551826
 |  |  |  |  |  |  |  |  |  |  |  | 7.39240644759616 |  |  |  | -8.799999999999999
 |  |  |  |  |  |  |  |  |  |  |  | -2.523731980534813
 |  |  |  |  |  |  |  |  |  |  |  | -0.624326747524006
 |  |  |  |  |  |  |  |  |  |  |  | 3.233412992243543
 |  |  |  |  |  |  |  |  |  |  |  | 2.612816825486969
 |  |  |  |  |  |  |  |  |  |  |  | 2.222933917950624
 |  |  |  |  |  |  |  |  |  |  |  | -0.5249068077400307
 |  |  |  |  |  |  |  |  |  |  |  | 0.595099918988082
 |  |  |  |  |  |  |  |  |  |  |  | 1.773248048345148
 |  |  |  |  |  |  |  |  |  |  |  | 1.504031297365305
 |  |  |  |  |  |  |  |  |  |  |  | -1.886125554700791
 |  |  |  |  |  |  |  |  |  |  |  | 0.728556527150181
 |  |  |  |  |  |  |  |  |  |  |  | 0.07720667170351377
 |  |  |  |  |  |  |  |  |  |  |  | 0.01119439138923602