Compare cell with column

Closed
amc - Mar 15, 2010 at 04:54 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 15, 2010 at 01:34 PM
Hello,

Hi i want a formula to compare for example IS136677 with the similar vaue from the right hand side which is shuffled eg. IS141158098.25 is also available in as IS141158098.25 in right side suggest a formula to compare

IS136677 IS1000150912.06
IS1363330 IS1000150912.06
IS1361499 IS1000150912.06
IS136251 IS10891464000
IS1363447 IS10893220152.39
IS141158098.25 IS10891444401.28
IS136929 IS10896127957.83
IS136421 IS10894862.57
IS1362069 IS10898253.23
IS136894 IS108920038.5
IS136896 IS108925766
IS1366997 IS10894424008.5
IS1364514 IS10891903031.25
IS1365001 IS10892565612.5
IS1363490 IS108910144.4
IS1369 IS10891909171.27
IS1363491 IS10891435600.31
IS1361877 IS10891018458.33
IS136518 IS10891303364.81
IS136344 IS10891329458.4
IS1411962379.19 IS10891761.64
IS1361481 IS10891292620.19
IS946243771.34 IS10893523745.88
IS1366882 IS10897244003.23
IS1361038 IS10891139222.22
IS791538838.24 IS10891960000
IS130427005.95 IS10891960000
IS136439 IS10895500000
IS130436951.08 IS108911500000
IS136617 IS10891424.42
IS136399 IS108925364
IS1362014 IS12159000
IS136505 IS12153513.71
IS142691917.98 IS1212387.97
IS136190 IS12179000
IS1362542 IS12178554.33
IS136610 IS121212.71
IS1362640 IS12161875.82
IS1361605 IS12153574.95
IS136448 IS121132978.72
IS1362513 IS121100590.96
IS121505500 IS121100660.96
IS13652579 IS121143953.4
IS1367407 IS121362000
IS1364473 IS121505500
IS813196216.52 IS121559.24
IS136118 IS12113325
IS910210373 IS1213048.98
IS136251 IS1213039.45
IS1362168 IS1211982.5
IS108925364 IS12171807.05
IS1363915 IS121841990.45
IS1361665 IS12115438.58
IS142415979.82 IS121200000
IS13041339745 IS121213121.07
IS1000150912.06 IS12113600
IS142556212.48 IS1211337000
IS881355380.81 IS130421351.57
IS1363 IS130411438.34
IS13614533 IS13049913.23
IS1362047 IS130463957.03
IS136570 IS130427005.95
IS136598 IS130436951.08
IS136609 IS130458092.17
IS130497857.18 IS130487372.25
IS1363546 IS130411199.6
IS776173334 IS130414435.04
IS130411199.6 IS130417614.12
IS136632 IS130412937.99
IS136674 IS130419079.52
IS1367 IS1304224480.07
IS136251 IS1304126622.89
IS813305553.15 IS130497857.18
IS818558068 IS13042415601
IS136596 IS13041339745
IS13634279 IS13041075856
IS136589 IS1304132500.01
IS136944 IS130457225.92
IS1366989 IS130475274.09
IS136508 IS136632
IS1362634 IS1363
IS136310 IS1367
IS1361556 IS136952
IS136490 IS1369
IS130414435.04 IS136157
IS136632 IS136439
IS136833 IS13612
IS1366729 IS13611
IS130457225.92 IS1362055
IS818173334 IS136251
IS136618 IS136295
IS136952 IS13634279
IS1365502 IS136190
IS96439500 IS136121
IS136121 IS136607
IS1361312 IS136490
IS136556 IS136518
IS1364841 IS136508
IS142260190.64 IS136466
IS136304 IS136344
IS1362000 IS136699
IS13621892 IS1361556
IS142465417.46 IS1362069
IS136157 IS13614533
IS136295 IS1361312
IS1368246 IS1361499
IS130411438.34 IS1363546
IS136559 IS1362047
IS1364621 IS1364514
IS1361111 IS1364841
IS1362254 IS1364764
IS1362055 IS136894
IS13612 IS1361254
IS121362000 IS1361659
IS1361254 IS1362254
IS13049913.23 IS1364473
IS141127246.72 IS1363915
IS136389 IS1366989
IS130475274.09 IS1366997
IS136466 IS1362014
IS136699 IS1363541
IS1361491 IS1362000
IS1362073 IS1361481
IS1361659 IS1361111
IS13041075856 IS136929
IS1363541 IS1361665
IS776597930 IS136166
IS136416 IS136304
IS141828034.51 IS1365001
IS136166 IS136448
IS13611 IS136833
IS136607 IS1365502
IS136166 IS1363491
IS82382026.96 IS1364621
IS1304126622.89 IS1363330
IS1363414 IS1363490
IS1364764 IS1362634
00 IS1362513
00 IS1362073
00 IS1361605
00 IS1361491
00 IS1362168
00 IS1366729
00 IS1366882
00 IS1367407
00 IS13652579
00 IS1363447
00 IS13621892
00 IS136118
00 IS136617
00 IS136310
00 IS136674
00 IS136596
00 IS136556
00 IS136559
00 IS136505
00 IS136389
00 IS136251
00 IS136632
IS136609
IS136598
IS136166
IS136399
IS136416
IS136677
IS136570
IS136944
IS136589
IS1368246
IS136610
IS1361038
IS136251
IS1362542
IS136618
IS136421
IS136896
IS1361877
IS1363414
IS1362640
IS1411341741.58
IS1411347360.86
IS1411348110
IS141700000
IS1411400000
IS1411287347.65
IS1411330487.57
IS141700000
IS1411325673.88
IS1411330509.7
IS1411400000
IS1411325527.45
IS1411336496.37
IS1411345857.28
IS141670376.83
IS141686490.75
IS1411338927.07
IS141668578.06
IS141666725.93
IS1411335871.49
IS1412712409.58
IS1411351655.78
IS1411400000
IS1411400000
IS1411346242.3
IS1411342897.75
IS1411400000
IS1411400000
IS1411333140.77
IS1411341126.77
IS1411400000
IS1411400000
IS1411353663
IS1411400000
IS1411300000
IS1411254066
IS1411266300
IS1411266548.4
IS1411287540
IS1411302320
IS1411266636
IS1411261602
IS1411251540
IS1411246248
IS1411263282
IS1411259556
IS1411267875
IS1411260000
IS1411239997.2
IS1411270588.8
IS1411292104
IS1411255041
IS1411338061.34
IS1411300000
IS1411234572
IS1411233672
IS141641570.85
IS1411260960
IS141734255
IS1411255500
IS1411260996
IS1411259220
IS1411354080
IS1411360786
IS1411341620
IS1411353240
IS1411297710
IS1411184548.31
IS1411292280
IS1411298112
IS1411342082
IS1411338708
IS1411297608
IS1411294860
IS1411293660
IS1411291260

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 15, 2010 at 01:34 PM
Could you explain again how matching is to happen ?
0