{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data","Input","Output"],"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":"Data","index":0,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Data Table",null,null,null,null,null,"Input Data",null,null,"Required Output like this"]
[]
["Product ID","Product Description","Product Group","Sr. No.","Unique",null,"Group","Req Qty",null,"Product ID","Product Description","Product Group"]
["A1","This is the first product","Group A",{"$f":"COUNTIF($C$4:$C$19,C4) - COUNTIF(C4:$C$19,C4) + 1","v":1},{"$f":"C4&D4","v":"Group A1"},null,"Group A",3,null,{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L4&(IF(AND($L4<>\"\",$L4>0),COUNTIF($L$4:$L$18,$L4)-COUNTIF($L4:$L$18,$L4)+1,\"\")),$E$4:$E$19,0),1), \"\")","v":"A1"},{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L4&(IF(AND($L4<>\"\",$L4>0),COUNTIF($L$4:$L$18,$L4)-COUNTIF($L4:$L$18,$L4)+1,\"\")),$E$4:$E$19,0),2), \"\")","v":"This is the first product"},{"$f":"G4","v":"Group A"}]
["A2","This is the second product","Group B",{"$f":"COUNTIF($C$4:$C$19,C5) - COUNTIF(C5:$C$19,C5) + 1","v":1},"Group B1",null,"Group D",2,null,{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L5&(IF(AND($L5<>\"\",$L5>0),COUNTIF($L$4:$L$18,$L5)-COUNTIF($L5:$L$18,$L5)+1,\"\")),$E$4:$E$19,0),1), \"\")","v":"A5"},{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L5&(IF(AND($L5<>\"\",$L5>0),COUNTIF($L$4:$L$18,$L5)-COUNTIF($L5:$L$18,$L5)+1,\"\")),$E$4:$E$19,0),2), \"\")","v":"This is the fifth product"},{"$f":"IFERROR(IF(COUNTIF($L$4:L4,L4)>=VLOOKUP(L4,$G$4:$H$9,2,0), OFFSET(INDEX($G$4:$G$9,MATCH(L4,$G$4:$G$9,0)),1,0),L4), \"\")","v":"Group A"}]
["A3","This is the third product","Group C",{"$f":"COUNTIF($C$4:$C$19,C6) - COUNTIF(C6:$C$19,C6) + 1","v":1},"Group C1",null,"Group C",1,null,{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L6&(IF(AND($L6<>\"\",$L6>0),COUNTIF($L$4:$L$18,$L6)-COUNTIF($L6:$L$18,$L6)+1,\"\")),$E$4:$E$19,0),1), \"\")","v":"A9"},{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L6&(IF(AND($L6<>\"\",$L6>0),COUNTIF($L$4:$L$18,$L6)-COUNTIF($L6:$L$18,$L6)+1,\"\")),$E$4:$E$19,0),2), \"\")","v":0},{"$f":"IFERROR(IF(COUNTIF($L$4:L5,L5)>=VLOOKUP(L5,$G$4:$H$9,2,0), OFFSET(INDEX($G$4:$G$9,MATCH(L5,$G$4:$G$9,0)),1,0),L5), \"\")","v":"Group A"}]
["A4","This is the fourth product","Group D",{"$f":"COUNTIF($C$4:$C$19,C7) - COUNTIF(C7:$C$19,C7) + 1","v":1},"Group D1",null,"Group B",2,null,{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L7&(IF(AND($L7<>\"\",$L7>0),COUNTIF($L$4:$L$18,$L7)-COUNTIF($L7:$L$18,$L7)+1,\"\")),$E$4:$E$19,0),1), \"\")","v":"A4"},{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L7&(IF(AND($L7<>\"\",$L7>0),COUNTIF($L$4:$L$18,$L7)-COUNTIF($L7:$L$18,$L7)+1,\"\")),$E$4:$E$19,0),2), \"\")","v":"This is the fourth product"},{"$f":"IFERROR(IF(COUNTIF($L$4:L6,L6)>=VLOOKUP(L6,$G$4:$H$9,2,0), OFFSET(INDEX($G$4:$G$9,MATCH(L6,$G$4:$G$9,0)),1,0),L6), \"\")","v":"Group D"}]
["A5","This is the fifth product","Group A",{"$f":"COUNTIF($C$4:$C$19,C8) - COUNTIF(C8:$C$19,C8) + 1","v":2},"Group A2",null,null,null,null,{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L8&(IF(AND($L8<>\"\",$L8>0),COUNTIF($L$4:$L$18,$L8)-COUNTIF($L8:$L$18,$L8)+1,\"\")),$E$4:$E$19,0),1), \"\")","v":""},{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L8&(IF(AND($L8<>\"\",$L8>0),COUNTIF($L$4:$L$18,$L8)-COUNTIF($L8:$L$18,$L8)+1,\"\")),$E$4:$E$19,0),2), \"\")","v":""},{"$f":"IFERROR(IF(COUNTIF($L$4:L7,L7)>=VLOOKUP(L7,$G$4:$H$9,2,0), OFFSET(INDEX($G$4:$G$9,MATCH(L7,$G$4:$G$9,0)),1,0),L7), \"\")","v":"Group D"}]
["A6","This is the sixth product","Group B",{"$f":"COUNTIF($C$4:$C$19,C9) - COUNTIF(C9:$C$19,C9) + 1","v":2},"Group B2",null,null,null,null,{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L9&(IF(AND($L9<>\"\",$L9>0),COUNTIF($L$4:$L$18,$L9)-COUNTIF($L9:$L$18,$L9)+1,\"\")),$E$4:$E$19,0),1), \"\")","v":"A3"},{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L9&(IF(AND($L9<>\"\",$L9>0),COUNTIF($L$4:$L$18,$L9)-COUNTIF($L9:$L$18,$L9)+1,\"\")),$E$4:$E$19,0),2), \"\")","v":"This is the third product"},{"$f":"IFERROR(IF(COUNTIF($L$4:L8,L8)>=VLOOKUP(L8,$G$4:$H$9,2,0), OFFSET(INDEX($G$4:$G$9,MATCH(L8,$G$4:$G$9,0)),1,0),L8), \"\")","v":"Group C"}]
["A7",null,"Group B",{"$f":"COUNTIF($C$4:$C$19,C10) - COUNTIF(C10:$C$19,C10) + 1","v":3},"Group B3",null,null,null,null,{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L10&(IF(AND($L10<>\"\",$L10>0),COUNTIF($L$4:$L$18,$L10)-COUNTIF($L10:$L$18,$L10)+1,\"\")),$E$4:$E$19,0),1), \"\")","v":"A2"},{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L10&(IF(AND($L10<>\"\",$L10>0),COUNTIF($L$4:$L$18,$L10)-COUNTIF($L10:$L$18,$L10)+1,\"\")),$E$4:$E$19,0),2), \"\")","v":"This is the second product"},{"$f":"IFERROR(IF(COUNTIF($L$4:L9,L9)>=VLOOKUP(L9,$G$4:$H$9,2,0), OFFSET(INDEX($G$4:$G$9,MATCH(L9,$G$4:$G$9,0)),1,0),L9), \"\")","v":"Group B"}]
["A8",null,"Group B",{"$f":"COUNTIF($C$4:$C$19,C11) - COUNTIF(C11:$C$19,C11) + 1","v":4},"Group B4",null,null,null,null,{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L11&(IF(AND($L11<>\"\",$L11>0),COUNTIF($L$4:$L$18,$L11)-COUNTIF($L11:$L$18,$L11)+1,\"\")),$E$4:$E$19,0),1), \"\")","v":"A6"},{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L11&(IF(AND($L11<>\"\",$L11>0),COUNTIF($L$4:$L$18,$L11)-COUNTIF($L11:$L$18,$L11)+1,\"\")),$E$4:$E$19,0),2), \"\")","v":"This is the sixth product"},{"$f":"IFERROR(IF(COUNTIF($L$4:L10,L10)>=VLOOKUP(L10,$G$4:$H$9,2,0), OFFSET(INDEX($G$4:$G$9,MATCH(L10,$G$4:$G$9,0)),1,0),L10), \"\")","v":"Group B"}]
["A9",null,"Group A",{"$f":"COUNTIF($C$4:$C$19,C12) - COUNTIF(C12:$C$19,C12) + 1","v":3},"Group A3",null,null,null,null,{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L12&(IF(AND($L12<>\"\",$L12>0),COUNTIF($L$4:$L$18,$L12)-COUNTIF($L12:$L$18,$L12)+1,\"\")),$E$4:$E$19,0),1), \"\")","v":""},{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L12&(IF(AND($L12<>\"\",$L12>0),COUNTIF($L$4:$L$18,$L12)-COUNTIF($L12:$L$18,$L12)+1,\"\")),$E$4:$E$19,0),2), \"\")","v":""},{"$f":"IFERROR(IF(COUNTIF($L$4:L11,L11)>=VLOOKUP(L11,$G$4:$H$9,2,0), OFFSET(INDEX($G$4:$G$9,MATCH(L11,$G$4:$G$9,0)),1,0),L11), \"\")","v":0}]
["A10",null,"Group B",{"$f":"COUNTIF($C$4:$C$19,C13) - COUNTIF(C13:$C$19,C13) + 1","v":5},"Group B5",null,null,null,null,{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L13&(IF(AND($L13<>\"\",$L13>0),COUNTIF($L$4:$L$18,$L13)-COUNTIF($L13:$L$18,$L13)+1,\"\")),$E$4:$E$19,0),1), \"\")","v":""},{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L13&(IF(AND($L13<>\"\",$L13>0),COUNTIF($L$4:$L$18,$L13)-COUNTIF($L13:$L$18,$L13)+1,\"\")),$E$4:$E$19,0),2), \"\")","v":""},{"$f":"IFERROR(IF(COUNTIF($L$4:L12,L12)>=VLOOKUP(L12,$G$4:$H$9,2,0), OFFSET(INDEX($G$4:$G$9,MATCH(L12,$G$4:$G$9,0)),1,0),L12), \"\")","v":""}]
["A11",null,"Group B",{"$f":"COUNTIF($C$4:$C$19,C14) - COUNTIF(C14:$C$19,C14) + 1","v":6},"Group B6",null,null,null,null,{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L14&(IF(AND($L14<>\"\",$L14>0),COUNTIF($L$4:$L$18,$L14)-COUNTIF($L14:$L$18,$L14)+1,\"\")),$E$4:$E$19,0),1), \"\")","v":""},{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L14&(IF(AND($L14<>\"\",$L14>0),COUNTIF($L$4:$L$18,$L14)-COUNTIF($L14:$L$18,$L14)+1,\"\")),$E$4:$E$19,0),2), \"\")","v":""},{"$f":"IFERROR(IF(COUNTIF($L$4:L13,L13)>=VLOOKUP(L13,$G$4:$H$9,2,0), OFFSET(INDEX($G$4:$G$9,MATCH(L13,$G$4:$G$9,0)),1,0),L13), \"\")","v":""}]
["A12",null,"Group A",{"$f":"COUNTIF($C$4:$C$19,C15) - COUNTIF(C15:$C$19,C15) + 1","v":4},"Group A4",null,null,null,null,{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L15&(IF(AND($L15<>\"\",$L15>0),COUNTIF($L$4:$L$18,$L15)-COUNTIF($L15:$L$18,$L15)+1,\"\")),$E$4:$E$19,0),1), \"\")","v":""},{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L15&(IF(AND($L15<>\"\",$L15>0),COUNTIF($L$4:$L$18,$L15)-COUNTIF($L15:$L$18,$L15)+1,\"\")),$E$4:$E$19,0),2), \"\")","v":""},{"$f":"IFERROR(IF(COUNTIF($L$4:L14,L14)>=VLOOKUP(L14,$G$4:$H$9,2,0), OFFSET(INDEX($G$4:$G$9,MATCH(L14,$G$4:$G$9,0)),1,0),L14), \"\")","v":""}]
["A13",null,"Group B",{"$f":"COUNTIF($C$4:$C$19,C16) - COUNTIF(C16:$C$19,C16) + 1","v":7},"Group B7",null,null,null,null,{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L16&(IF(AND($L16<>\"\",$L16>0),COUNTIF($L$4:$L$18,$L16)-COUNTIF($L16:$L$18,$L16)+1,\"\")),$E$4:$E$19,0),1), \"\")","v":""},{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L16&(IF(AND($L16<>\"\",$L16>0),COUNTIF($L$4:$L$18,$L16)-COUNTIF($L16:$L$18,$L16)+1,\"\")),$E$4:$E$19,0),2), \"\")","v":""},{"$f":"IFERROR(IF(COUNTIF($L$4:L15,L15)>=VLOOKUP(L15,$G$4:$H$9,2,0), OFFSET(INDEX($G$4:$G$9,MATCH(L15,$G$4:$G$9,0)),1,0),L15), \"\")","v":""}]
["A14",null,"Group A",{"$f":"COUNTIF($C$4:$C$19,C17) - COUNTIF(C17:$C$19,C17) + 1","v":5},"Group A5",null,null,null,null,{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L17&(IF(AND($L17<>\"\",$L17>0),COUNTIF($L$4:$L$18,$L17)-COUNTIF($L17:$L$18,$L17)+1,\"\")),$E$4:$E$19,0),1), \"\")","v":""},{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L17&(IF(AND($L17<>\"\",$L17>0),COUNTIF($L$4:$L$18,$L17)-COUNTIF($L17:$L$18,$L17)+1,\"\")),$E$4:$E$19,0),2), \"\")","v":""},{"$f":"IFERROR(IF(COUNTIF($L$4:L16,L16)>=VLOOKUP(L16,$G$4:$H$9,2,0), OFFSET(INDEX($G$4:$G$9,MATCH(L16,$G$4:$G$9,0)),1,0),L16), \"\")","v":""}]
["A15",null,"Group A",{"$f":"COUNTIF($C$4:$C$19,C18) - COUNTIF(C18:$C$19,C18) + 1","v":6},"Group A6",null,null,null,null,{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L18&(IF(AND($L18<>\"\",$L18>0),COUNTIF($L$4:$L$18,$L18)-COUNTIF($L18:$L$18,$L18)+1,\"\")),$E$4:$E$19,0),1), \"\")","v":""},{"$f":"IFERROR(INDEX($A$4:$B$19,MATCH($L18&(IF(AND($L18<>\"\",$L18>0),COUNTIF($L$4:$L$18,$L18)-COUNTIF($L18:$L$18,$L18)+1,\"\")),$E$4:$E$19,0),2), \"\")","v":""},{"$f":"IFERROR(IF(COUNTIF($L$4:L17,L17)>=VLOOKUP(L17,$G$4:$H$9,2,0), OFFSET(INDEX($G$4:$G$9,MATCH(L17,$G$4:$G$9,0)),1,0),L17), \"\")","v":""}]
["A16",null,"Group A",{"$f":"COUNTIF($C$4:$C$19,C19) - COUNTIF(C19:$C$19,C19) + 1","v":7},"Group A7"]
[]
[null,null,null,null,"Extra Columns"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND($L12<>\"\", $L12>0),COUNTIF($L$4:$L$18,$L12)-COUNTIF(L12:$L$18,$L12)+1,\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND($L13<>\"\", $L13>0),COUNTIF($L$4:$L$18,$L13)-COUNTIF(L13:$L$18,$L13)+1,\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND($L14<>\"\", $L14>0),COUNTIF($L$4:$L$18,$L14)-COUNTIF(L14:$L$18,$L14)+1,\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND($L15<>\"\", $L15>0),COUNTIF($L$4:$L$18,$L15)-COUNTIF(L15:$L$18,$L15)+1,\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND($L16<>\"\", $L16>0),COUNTIF($L$4:$L$18,$L16)-COUNTIF(L16:$L$18,$L16)+1,\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND($L17<>\"\", $L17>0),COUNTIF($L$4:$L$18,$L17)-COUNTIF(L17:$L$18,$L17)+1,\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND($L18<>\"\", $L18>0),COUNTIF($L$4:$L$18,$L18)-COUNTIF(L18:$L$18,$L18)+1,\"\")","v":""}]

{"sheet":"Input","index":1,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Group","Req Qty"]
["Group A",3]
["Group D",2]
["Group C",1]
["Group B",2]

{"sheet":"Output","index":2,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Product ID","Product Description","Product Group"]