{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Formula & Filter","CONCAT","TEXTJOIN","UDF"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Formula & Filter","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Join Cells Based on Criteria : Formula & Filter"]
[]
[null,"Code","Color","Concatenation","Filter"]
[null,"G","Green",{"$f":"IF(B5<>B4,C5,D4&\",\"&C5)","v":"Green"},{"$f":"IF(B5<>B6,_xlfn.CONCAT(B5,\",\"\"\",D5,\"\"\"\"),\"\")","v":""}]
[null,"G","Green",{"$f":"IF(B6<>B5,C6,D5&\",\"&C6)","v":"Green,Green"},{"$f":"IF(B6<>B7,_xlfn.CONCAT(B6,\",\"\"\",D6,\"\"\"\"),\"\")","v":"G,\"Green,Green\""}]
[null,"R","Red","Red",""]
[null,"R","Red","Red,Red","R,\"Red,Red\""]
[null,"Y","Yellow","Yellow",""]
[null,"Y","Yellow","Yellow,Yellow",""]
[null,"Y","Yellow","Yellow,Yellow,Yellow","Y,\"Yellow,Yellow,Yellow\""]
[null,"V","Violet","Violet","V,\"Violet\""]
[null,"O","Orange","Orange","O,\"Orange\""]
[null,"B","Blue","Blue",""]
[null,"B","Blue","Blue,Blue",""]
[null,"B","Blue","Blue,Blue,Blue","B,\"Blue,Blue,Blue\""]
[]
[]
[]
[]
[]
[null,null,null,null,null,"IF(B5<>B4,C5,D4&\",\"&C5)","IF(B5<>B6,CONCAT(B5,\",\"\"\",D5,\"\"\"\"),\"\")"]

{"sheet":"CONCAT","index":1,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Join Cells Based on Criteria : CONCAT Function"]
[]
[null,"Code","Color",null,"Criteria (Color)","Concatenation"]
[null,"A","Blue",null,"Blue",{"$f":"_xlfn.CONCAT(IF(C5:C16=E5,B5:B16,\"\"))","v":"AJL"}]
[null,"B","Green"]
[null,"C","Red"]
[null,"D","Red"]
[null,"E","Yellow"]
[null,"F","Green"]
[null,"G","Yellow"]
[null,"H","Violet"]
[null,"I","Orange"]
[null,"J","Blue"]
[null,"K","Yellow"]
[null,"L","Blue"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"CONCAT(IF(C5:C16=E5,B5:B16,\"\"))"]

{"sheet":"TEXTJOIN","index":2,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Join Cells Based on Criteria : TEXTJOIN Function"]
[]
[null,"St. ID","Marks",null,"Criteria (Marks<=)","Concatenation"]
[null,1,95,null,80,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,IF($C$5:$C$16<=E5,$B$5:$B$16,\"\"))","v":"4,5,6,8,9,10,12"}]
[null,2,82]
[null,3,85]
[null,4,77]
[null,5,80]
[null,6,80]
[null,7,82]
[null,8,75]
[null,9,76]
[null,10,74]
[null,11,91]
[null,12,80]
[]
[]
[]
[null,null,null,null,null,"TEXTJOIN(\",\",TRUE,IF($C$5:$C$16>E5,$B$5:$B$16,\"\"))"]

{"sheet":"UDF","index":3,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Join Cells Based on Criteria : User Defined Function"]
[]
[null,"Roll","Marks",null,"Criteria (Marks)","Concatenation"]
[null,1,85,null,{"$f":"_xlfn.UNIQUE(C5:C16,FALSE,FALSE)","v":85},{"$f":"CONCATIF($C$5:$C$16,E5,$B$5:$B$16,\",\")","v":"1,3,9"}]
[null,2,82,null,82,{"$f":"CONCATIF($C$5:$C$16,E6,$B$5:$B$16,\",\")","v":"2,7,8"}]
[null,3,85,null,95,{"$f":"CONCATIF($C$5:$C$16,E7,$B$5:$B$16,\",\")","v":"4,10"}]
[null,4,95,null,80,{"$f":"CONCATIF($C$5:$C$16,E8,$B$5:$B$16,\",\")","v":"5,6,11,12"}]
[null,5,80]
[null,6,80]
[null,7,82]
[null,8,82]
[null,9,85]
[null,10,95]
[null,11,80]
[null,12,80]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"UNIQUE(C5:C16,FALSE,FALSE)",null,"CONCATIF($C$5:$C$16,E5,$B$5:$B$16,\",\")"]