Spreadsheet: 878378d1725451766-finding-closest-match-in-large-dataset-finding-closest-match-in-large-dataset-2-
Sheet: Sheet2 (3)

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]) |  |  | Count of difference > Tolerance % |  |  | Count of ABS difference > Tolerance %
Location | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | Aggregate | Aggregate | Least Square | CORREL | Subtraction | Division | Division | Subtraction | Division | Division
1 | 0 | 0 | 0.03161287148199173 | 0.3293888998228695 | 0.0006642393229679197 | 0.2146477071442629 | 0.03077642196418028 | 0 | 0 | 0.1377189529620154 | 0.08231647313520961 | 0.009742176736862822 | 0.04351997638260185 | 0 | 0.01013580003936233 | 0.02221511513481598 | 0.0411582365676048 | 0.001918913599685101 | 0 | 0.008389096634520764 | 0.01158728596732927 | 0.02302696319622122
2 | 0 | 0.002476718842876957 | 0.07754606697047751 | 0.3189023182088369 | 0.06402318208836932 | 0.01604913810184268 | 0.1147216168020606 | 0 | 0.04103923122647117 | 0.1525658807212205 | 0.004061818902318209 | 0.007157717455914404 | 0.07583713096889241 | 0 | 0.002674856350307113 | 0.05986229443233604 | 0.02105211016445413 | 0.005696453338617001 | 0 | 0.01020408163265306 | 0.009708737864077669 | 0.01637111155141668
3 | 0 | 0 | 0.1513208158729424 | 0.3341050633204454 | 0.00833468386081078 | 0.03968235593730465 | 0.1527793855485843 | 0.02590697566735351 | 0.02292038061722964 | 0.00854305095733105 | 0.02085986155164031 | 0.04968397657027759 | 0.003588544440071308 | 0.0003935822934271757 | 0.004607228023059292 | 0.05463848308753733 | 0.05574977426897877 | 0.002778227953603593 | 0.00833468386081078 | 0.007894797768156877 | 0.04547033084064547 | 0.001643784872548793
4 | 0 | 0.0009831530886004233 | 0.1171285264368199 | 0.3586175867757578 | 0.005815600473246571 | 0.009181650030827682 | 0.1332755661462065 | 0 | 0.04962423555681458 | 0.05870590391761511 | 0.009414940594224392 | 0.01558047691256603 | 0.03396044058589259 | 0 | 0.001616370332105781 | 0.05355684791121627 | 0.02381230107813568 | 0.05548982686507473 | 0.02471213610838013 | 0.0125310359767376 | 0.03007781906650447 | 0.005265701288097182
5 | 0 | 0 | 0.02634193682556554 | 0.3339649236314902 | 0.003881969637451764 | 0.0581602236753934 | 0.08581925734223722 | 0 | 0.0007163158259583613 | 0.2448413707049934 | 0.04327934006516163 | 0.01968713173279109 | 0.06437599648774175 | 0 | 0.03452180141876748 | 0.01291679182937819 | 0.03650900016174873 | 0.008341613328095755 | 0.001270882917022899 | 0.01009774244980012 | 0.01146105321533378 | 0.00374332786468563
6 | 0 | 0 | 0.05066827589289705 | 0.3313888516382817 | 0.001050467122614099 | 0.0991685664476331 | 0.05127173572929239 | 0 | 0.00645925528586116 | 0.1633141120200259 | 0.05274685977381431 | 0.0152429484600599 | 0.06606767690313352 | 0 | 0.0433373563989093 | 0.02818380939609316 | 0.03426310848866836 | 0.01667337177595995 | 0.0004693576505297036 | 0.01457243753073175 | 0.01101872960529257 | 0.01345491931518484
7 | 0 | 0.02171677030249193 | 0.3332086586563187 | 0.3239983168918603 | 0.008392164196549628 | 0.01617653934265276 | 0.09755014259666184 | 0 | 0.02828556734770209 | 0.03020244050680256 | 0.01023890784982935 | 0.0172752349338445 | 0.02774790780307635 | 0 | 0.002103885174622469 | 0.007620739632521389 | 0.01645705736593576 | 0.01825704801533498 | 0.01119734442937959 | 0.007293468605357894 | 0.01657393987563701 | 0.005283089438496424
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tolerance % | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05
Example