{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Feuil1","index":0,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Sortie attendu",null,"Control","Sortie en cours",null,"Formule en C"]
[null,1,{"$f":"test(B4,$E$4:$E$8)","v":"doublon"},{"$f":"IF(COUNTIF($E$4:$E$200,B4)>1,\"Doublon\",IFERROR(VLOOKUP(B4,$E$4:$E$200,1,0),\"Absent\"))","v":"Doublon"},1,null,"SI(NB.SI($D$4:$D$200;B4)>1;\"Doublon\";SIERREUR(RECHERCHEV(B4;$D$4:$D$200;1;0);\"Absent\"))"]
[null,2,{"$f":"test(B5,$E$4:$E$8)","v":"absent"},{"$f":"IF(COUNTIF($E$4:$E$200,B5)>1,\"Doublon\",IFERROR(VLOOKUP(B5,$E$4:$E$200,1,0),\"Absent\"))","v":"Absent"},1]
[null,3,{"$f":"test(B6,$E$4:$E$8)","v":"3"},3,3,null,"si en colonne D la reference en sortie n est pas présente en colonne B alors message \" reference non attendu\""]
[null,4,{"$f":"test(B7,$E$4:$E$8)","v":"4"},4,4]
[null,5,{"$f":"test(B8,$E$4:$E$8)","v":"5"},5,5]
[null,null,{"$f":"test(B9,$E$4:$E$8)","v":"absent"},"Absent"]
[null,null,null,"Absent"]
[null,null,null,"Absent",null,null,"ou alors en vba si possible "]
[null,null,null,"Absent"]
[null,null,null,"Absent",null,null,"si en colonne D  la reference est presente  en B on colorie la cellule en vert"]
[null,null,null,null,null,null,"si en colonne D  la reference a déjà été trouver msgbox \" doublon\""]
[null,null,null,null,null,null,"si en colonne D la reference en sortie n est pas présente en colonne B alors message \" reference non attendu\""]
[]
[null,null,null,null,null,null,"les references sont unique ,il ne peut avoir de doublon"]