Spreadsheet: 167349d1341956879-update-if-statement-or-another-solution-see-attachment-bom_testinganswer
Sheet: Sheet2

 |  | RECTY | MATNR BOM | MATNR MARC | Blank | Similarity | IDNRK | MATNR MARC | POSNR | Similarity2 | Desired result |  |  | RECTY | MATNR BOM | MATNR MARC |  | Similarity | IDNRK | MATNR MARC | POSNR | Similarity2 | Desired result |  |  | MATNR BOM
 |  | H | 9L-8144-K000-01 | 9L-8140-K000-01 |  | 0.9559748427672956 |  |  |  |  | Delete |  |  |  |  |  |  | <1
 |  | H | 9L-8144-K000-02 | 9L-8140-K000-02 |  | 0.9580838323353293 |  |  |  |  | Delete |  |  |  |  |  |  |  |  |  |  | <1
 |  | D | 9L-8144-K000-02 |  |  |  | 9L-50HN0016 | 9L-50HN0016 | 10 | 1 | Delete |  |  | 1st Advanced Filter |  |  |  |  |  |  |  |  |  |  |  | Second Advanced Filter |  |  |  |  |  | Third Advanced Filter
 |  | H | 9L-8144-L000 | 9L-8144-L000 |  | 1 |  |  |  |  |  |  |  | Advanced Filter to find <1 Similarity (need to rename second to a different word) |  |  |  |  |  |  |  |  |  |  |  | Advanced Unique Filter to show what BOM to delete.
 |  | D | 9L-8144-L000 |  |  |  | 9L-8144-L000-01 | 9L-8144-L000-01 | 10 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MATNR BOM | MATNR BOM | MATNR BOM | MATNR BOM
 |  | D | 9L-8144-L000 |  |  |  | 9L-8144-L000-02 | 9L-8144-L000-02 | 20 | 1 |  |  |  | RECTY | MATNR BOM | MATNR MARC | Blank | Similarity | IDNRK | MATNR MARC | POSNR | Similarity2 | Desired result |  |  | MATNR BOM |  |  |  |  |  | <>9L-8144-K000-01 | <>9L-8144-K000-02 | <>9L-8144-L000-01 | <>9L-8144-L000-02
 |  | D | 9L-8144-L000 |  |  |  | 9L-20PW2011 | 9L-20PW2011 | 30 | 1 |  |  |  | H | 9L-8144-K000-01 | 9L-8140-K000-01 |  | 0.9559748427672956 |  | 9L-8140-K000-01 |  |  | Delete |  |  | 9L-8144-K000-01
 |  | D | 9L-8144-L000 |  |  |  | 9L-40GL0075 | 9L-40GL0075 | 40 | 1 |  |  |  | H | 9L-8144-K000-02 | 9L-8140-K000-02 |  | 0.9580838323353293 |  | 9L-8140-K000-02 |  |  | Delete |  |  | 9L-8144-K000-02 |  |  |  |  | Answer is here!!!
 |  | D | 9L-8144-L000 |  |  |  | 9L-40GL0077 | 9L-40GL0077 | 50 | 1 |  |  |  | D | 9L-8144-L000-01 |  |  |  | 9L-8144-M000-01 |  | 40 | 0.9559748427672956 | Delete |  |  | 9L-8144-L000-01 |  |  |  |  | RECTY | MATNR BOM | MATNR MARC | Blank | Similarity | IDNRK | MATNR MARC | POSNR | Similarity2 | Desired result
 |  | H | 9L-8144-L000-01 | 9L-8144-L000-01 |  | 1 |  |  |  |  | Delete |  |  | D | 9L-8144-L000-01 |  |  |  | 9L-8144-K000-01 |  | 50 | 0.9559748427672956 | Delete |  |  | 9L-8144-L000-02 |  |  |  |  | H | 9L-8144-L000 | 9L-8144-L000 |  | 1 |  | 9L-8144-L000
 |  | D | 9L-8144-L000-01 |  |  |  | 9L-8144-L001 | 9L-8144-L001 | 10 | 1 | Delete |  |  | D | 9L-8144-L000-02 |  |  |  | 9L-8144-M000-02 |  | 30 | 0.9580838323353293 | Delete |  |  |  |  |  |  |  | D | 9L-8144-L000 |  |  |  | 9L-8144-L000-01 |  | 10 | 1
 |  | D | 9L-8144-L000-01 |  |  |  | 9L-8144-L002 | 9L-8144-L002 | 20 | 1 | Delete |  |  | D | 9L-8144-L000-02 |  |  |  | 9L-8144-K000-02 |  | 40 | 0.9580838323353293 | Delete |  |  |  |  |  |  |  | D | 9L-8144-L000 |  |  |  | 9L-8144-L000-02 |  | 20 | 1
 |  | D | 9L-8144-L000-01 |  |  |  | 9L-8144-L003 | 9L-8144-L003 | 30 | 1 | Delete |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L000 |  |  |  | 9L-20PW2011 |  | 30 | 1
 |  | D | 9L-8144-L000-01 |  |  |  | 9L-8144-M000-01 | 9L-8140-M000-01 | 40 | 0.9559748427672956 | Delete |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L000 |  |  |  | 9L-40GL0075 |  | 40 | 1
 |  | D | 9L-8144-L000-01 |  |  |  | 9L-8144-K000-01 | 9L-8140-K000-01 | 50 | 0.9559748427672956 | Delete |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L000 |  |  |  | 9L-40GL0077 |  | 50 | 1
 |  | H | 9L-8144-L000-02 | 9L-8144-L000-02 |  | 1 |  |  |  |  | Delete |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | 9L-8144-L001 | 9L-8144-L001 |  | 1 |  | 9L-8144-L001
 |  | D | 9L-8144-L000-02 |  |  |  | 9L-8144-L004 | 9L-8144-L004 | 10 | 1 | Delete |  |  |  | MATNR BOM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-04AC1003 |  | 10 | 1
 |  | D | 9L-8144-L000-02 |  |  |  | 9L-8144-L005 | 9L-8144-L005 | 20 | 1 | Delete |  |  |  | 9L-8144-K000-01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-23ST1002 |  | 20 | 1
 |  | D | 9L-8144-L000-02 |  |  |  | 9L-8144-M000-02 | 9L-8140-M000-02 | 30 | 0.9580838323353293 | Delete |  |  |  | 9L-8144-K000-02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-23AC1004 |  | 30 | 1
 |  | D | 9L-8144-L000-02 |  |  |  | 9L-8144-K000-02 | 9L-8140-K000-02 | 40 | 0.9580838323353293 | Delete |  |  |  | 9L-8144-L000-01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-23AC1005 |  | 40 | 1
 |  | H | 9L-8144-L001 | 9L-8144-L001 |  | 1 |  |  |  |  |  |  |  |  | 9L-8144-L000-02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-09IC1030 |  | 50 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-04AC1003 | 9L-04AC1003 | 10 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-09AC1029 |  | 60 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-23ST1002 | 9L-23ST1002 | 20 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-09UV0393 |  | 70 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-23AC1004 | 9L-23AC1004 | 30 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-08CT0081 |  | 80 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-23AC1005 | 9L-23AC1005 | 40 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-05ST0010 |  | 90 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-09IC1030 | 9L-09IC1030 | 50 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-08PT0036 |  | 100 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-09AC1029 | 9L-09AC1029 | 60 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-01TD0232 |  | 110 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-09UV0393 | 9L-09UV0393 | 70 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-06CR0002 |  | 120 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-08CT0081 | 9L-08CT0081 | 80 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-07CR0004 |  | 130 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-05ST0010 | 9L-05ST0010 | 90 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-07CR0041 |  | 140 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-08PT0036 | 9L-08PT0036 | 100 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-07CR0044 |  | 150 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-01TD0232 | 9L-01TD0232 | 110 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-16LE0038 |  | 160 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-06CR0002 | 9L-06CR0002 | 120 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-16LE0039 |  | 170 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-07CR0004 | 9L-07CR0004 | 130 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-16LE0035 |  | 180 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-07CR0041 | 9L-07CR0041 | 140 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-16LE0034 |  | 190 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-07CR0044 | 9L-07CR0044 | 150 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-17CR0025 |  | 200 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-16LE0038 | 9L-16LE0038 | 160 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-18CR0027 |  | 210 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-16LE0039 | 9L-16LE0039 | 170 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-73SH0001 |  | 220 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-16LE0035 | 9L-16LE0035 | 180 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-25TM0003 |  | 230 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-16LE0034 | 9L-16LE0034 | 190 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-05CR0039 |  | 240 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-17CR0025 | 9L-17CR0025 | 200 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-05CR0037 |  | 250 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-18CR0027 | 9L-18CR0027 | 210 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-05CR0034 |  | 260 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-73SH0001 | 9L-73SH0001 | 220 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-06CR1001 |  | 270 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-25TM0003 | 9L-25TM0003 | 230 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-23CN2004 |  | 280 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-05CR0039 | 9L-05CR0039 | 240 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-07CR0235 |  | 290 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-05CR0037 | 9L-05CR0037 | 250 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | [NAME] |  | 300 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-05CR0034 | 9L-05CR0034 | 260 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-05AC0027 |  | 310 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-06CR1001 | 9L-06CR1001 | 270 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-05AC0031 |  | 320 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-23CN2004 | 9L-23CN2004 | 280 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-05AC0057 |  | 330 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-07CR0235 | 9L-07CR0235 | 290 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9L-8144-L001 |  |  |  | 9L-11CT1000 |  | 340 | 1
 |  | D | 9L-8144-L001 |  |  |  | [NAME] | [NAME] | 300 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-05AC0027 | 9L-05AC0027 | 310 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-05AC0031 | 9L-05AC0031 | 320 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-05AC0057 | 9L-05AC0057 | 330 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-11CT1000 | 9L-11CT1000 | 340 | 1