Spreadsheet: 815458d1674959639-if-formula-based-on-finding-two-of-the-same-value-in-a-range-book2
Sheet: Highest producers

 |  |  |  |  |  |  |  |  |  |  | Location avg dif |  |  |  |  |  |  |  |  |  |  |  | Ratio
 |  |  |  |  |  |  |  |  |  |  | BY | MG | SP | CI | GN | WG | ST | WH | WY |  |  |  | BY | MG | SP | CI | GN | WG | ST | WH | WY |  | BY | MG | SP | CI | GN | WG | ST | WH | WY
 |  |  |  |  |  |  |  |  |  |  | -110 | -110 | -110 | -110 | -110 | -110 | -110 | -110 | -110
 |  |  |  |  |  |  |  |  |  |  | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200
 |  |  |  |  |  |  |  |  |  |  | 145 | 150 | 148 | 130 | 145 | 150 | 145 | 139 | 145
 |  |  |  |  |  |  |  |  |  |  | 172 | 170 | 170 | 181 | 170 | 170 | 170 | 162 | 170
 |  |  |  |  |  |  |  |  |  |  | -215 | -200 | -190 | -205 | -190 | -190 | -190 | -195 | -200
 |  |  |  |  |  |  |  |  |  |  | -124 | -120 | -120 | -125 | -125 | -125 | -120 | -125 | -122
 |  |  |  |  |  |  |  |  |  |  | 102 | 100 | 100 | 105 | 105 | 105 | 100 | 105 | 105
 |  |  |  |  |  |  |  |  |  |  | -160 | -155 | -150 | -145 | -150 | -145 | -145 | -155 | -150
 |  |  |  |  |  |  |  |  |  |  | -188 | -200 | -185 | -187 | -180 | -185 | -190 | -180 | -200
 |  |  |  |  |  |  |  |  |  |  | -162 | -160 | -155 | -152 | -150 | -153 | -155 | -160 | -155
 |  |  |  |  |  |  |  |  |  |  | -180 | -190 | -185 | -186 | -190 | -185 | -185 | -190 | -178
 |  |  |  |  |  |  |  |  |  |  | -120 | -120 | -120 | -120 | -120 | -120 | -120 | -120 | -120
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AH3 is the formula
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Need it to be that a 2nd identical cell is entered in W35:W50 before any of the columns in AH through AP are made blank
 |  |  |  |  |  |  |  |  |  |  | BY | MG | SP | CI | GN | WG | ST | WH | WY |  |  | Chosen
 |  |  |  |  |  |  |  |  |  | 1ST SET | 1355.889127837515 | 1389.492943548387 | 1425.120967741936 | 1487.726705989111 | 1417.5 | 1425.780730223124 | 1444.777808676307 | 1323.807822580645 | 1425.780730223124 |  |  | CI
 |  |  |  |  |  |  |  |  |  | 2ND SET | 1304.137634408602 | 1305.11078098472 | 1334.493243243244 | 1379.810022246942 | 1298.131578947369 | 1328.301863932899 | 1352.900046598323 | 1243.414634974533 | 1324.51 |  |  |  | <---- Need it to require a 2nd CI here before AK3:AK16 is left ""
 |  |  |  |  |  |  |  |  |  | 3rd SET | 1278.219537863189 | 1266.890625 | 1317.273975588492 | 1351.342286799887 | 1323 | 1299.953418124006 | 1305.11078098472 | 1251.705 | 1289.45
 |  |  |  |  |  |  |  |  |  | 4th SET | 1229.432532601235 | 1189.953947368421 | 1233.504565376187 | 1253.318652751423 | 1211.589473684211 | 1211.077209642075 | 1222.114864864865 | 1175.69052631579 | 1126.75
 |  |  |  |  |  |  |  |  |  | 5th SET | 1516.174592592593 | 1515.810483870968 | 1554.677419354839 | 1694.355415154265 | 1614.375 | 1623.805831643002 | 1576.121245828699 | 1507.67002016129 | 1543.29
 |  |  |  |  |  |  |  |  |  | 6th SET | 1458.305333333333 | 1423.757215619694 | 1455.810810810811 | 1571.450303114572 | 1478.427631578947 | 1512.788233923579 | 1475.890959925443 | 1416.111112054329 | 1434.54
 |  |  |  |  |  |  |  |  |  | 7th SET | 1429.323347517731 | 1382.0625 | 1437.026155187446 | 1539.028715522094 | 1506.75 | 1480.502503974563 | 1423.757215619694 | 1425.552916666667 | 1436.84
 |  |  |  |  |  |  |  |  |  | 8th SET | 1374.769021276596 | 1298.131578947369 | 1345.64134404675 | 1427.390687855787 | 1379.865789473684 | 1379.282377647918 | 1333.216216216216 | 1338.980877192983 | 1350.19
 |  |  |  |  |  |  |  |  |  | 9th SET | 730.3438359589899 | 771.9405241935485 | 805.6239388794568 | 787.703576645567 | 801.3157894736842 | 805.9969040247678 | 816.7359932088287 | 764.383064516129 | 798.52
 |  |  |  |  |  |  |  |  |  | 10th SET | 702.4681170292572 | 725.061544991511 | 754.3918918918919 | 730.5651536938062 | 733.8365650969529 | 750.891891891892 | 764.7972972972974 | 717.9630403552305 | 751.03
 |  |  |  |  |  |  |  |  |  | 11th SET | 688.5074460104388 | 703.8281250000002 | 744.6578029642546 | 715.4924007880664 | 747.8947368421052 | 734.8664546899842 | 737.7819229738182 | 722.7500000000002 | 742.98
 |  |  |  |  |  |  |  |  |  | 12th SET | 662.2285358573686 | 661.0855263157896 | 697.3027757487217 | 663.5920303605313 | 684.9141274238228 | 684.6245434623814 | 690.8641536273116 | 678.8582995951418 | 690.61
 |  |  |  |  |  |  |  |  |  | 13th SET | 816.6809108527132 | 842.116935483871 | 878.8624787775891 | 897.1068511796734 | 912.6096491228068 | 917.9409184726522 | 890.9847198641767 | 870.5473790322582 | 915.36
 |  |  |  |  |  |  |  |  |  | 14th SET | 785.5098837209302 | 790.9762308998302 | 822.972972972973 | 832.0325361512794 | 835.7583102493073 | 855.1824324324325 | 834.3243243243244 | 817.6801292934568 | 824.65
 |  |  |  |  |  |  |  |  |  | 15th SET | 769.89886194953 | 767.8125000000001 | 812.353966870096 | 814.8663453419646 | 851.7690058479532 | 836.931240063593 | 804.8530068805289 | 823.1319444444445 | 840.4
 |  |  |  |  |  |  |  |  |  | 16th SET | 740.5134092033647 | 721.1842105263157 | 760.6939371804237 | 755.7575901328273 | 780.0410895660202 | 779.7112856099342 | 753.669985775249 | 773.1441745389113 | 789.31