{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"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":"Sheet1","index":0,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Date","Batch no","Qty","L T NO","Variety",null,null,null,"Batch no","L T NO","L T NO","L T NO","L T NO"]
["2010-04-08",10040219,265,"10-2368","S-275",null,null,null,10040220,{"$f":"IFERROR(OFFSET($D$1,SMALL(IF($B$2:$B$14=$I2,ROW($D$2:$D$14)-1,\"\"),(COLUMN(J1)-\"9\")/1 ),0),\"\")","v":"10-2366"},{"$f":"IFERROR(OFFSET($D$1,SMALL(IF($B$2:$B$14=$I2,ROW($D$2:$D$14)-1,\"\"),(COLUMN(K1)-\"9\")/1 ),0),\"\")","v":""},{"$f":"IFERROR(OFFSET($D$1,SMALL(IF($B$2:$B$14=$I2,ROW($D$2:$D$14)-1,\"\"),(COLUMN(L1)-\"9\")/1 ),0),\"\")","v":""},{"$f":"IFERROR(OFFSET($D$1,SMALL(IF($B$2:$B$14=$I2,ROW($D$2:$D$14)-1,\"\"),(COLUMN(M1)-\"9\")/1 ),0),\"\")","v":""}]
["2010-04-09",10040220,311,"10-2366","S-275",null,null,null,10040221,{"$f":"IFERROR(OFFSET($D$1,SMALL(IF($B$2:$B$14=$I3,ROW($D$2:$D$14)-1,\"\"),(COLUMN(J2)-\"9\")/1 ),0),\"\")","v":"10-2372"},{"$f":"IFERROR(OFFSET($D$1,SMALL(IF($B$2:$B$14=$I3,ROW($D$2:$D$14)-1,\"\"),(COLUMN(K2)-\"9\")/1 ),0),\"\")","v":"10-4560"},{"$f":"IFERROR(OFFSET($D$1,SMALL(IF($B$2:$B$14=$I3,ROW($D$2:$D$14)-1,\"\"),(COLUMN(L2)-\"9\")/1 ),0),\"\")","v":"10-34560"},{"$f":"IFERROR(OFFSET($D$1,SMALL(IF($B$2:$B$14=$I3,ROW($D$2:$D$14)-1,\"\"),(COLUMN(M2)-\"9\")/1 ),0),\"\")","v":""}]
["2010-04-10",10040221,265,"10-2372","S-275",null,null,null,10040222,{"$f":"IFERROR(OFFSET($D$1,SMALL(IF($B$2:$B$14=$I4,ROW($D$2:$D$14)-1,\"\"),(COLUMN(J3)-\"9\")/1 ),0),\"\")","v":"10-2370"},{"$f":"IFERROR(OFFSET($D$1,SMALL(IF($B$2:$B$14=$I4,ROW($D$2:$D$14)-1,\"\"),(COLUMN(K3)-\"9\")/1 ),0),\"\")","v":"10-9840"},{"$f":"IFERROR(OFFSET($D$1,SMALL(IF($B$2:$B$14=$I4,ROW($D$2:$D$14)-1,\"\"),(COLUMN(L3)-\"9\")/1 ),0),\"\")","v":""},{"$f":"IFERROR(OFFSET($D$1,SMALL(IF($B$2:$B$14=$I4,ROW($D$2:$D$14)-1,\"\"),(COLUMN(M3)-\"9\")/1 ),0),\"\")","v":""}]
["2010-04-11",10040222,480,"10-2370","S-275",null,null,null,10040223,{"$f":"IFERROR(OFFSET($D$1,SMALL(IF($B$2:$B$14=$I5,ROW($D$2:$D$14)-1,\"\"),(COLUMN(J4)-\"9\")/1 ),0),\"\")","v":"10-2362"},{"$f":"IFERROR(OFFSET($D$1,SMALL(IF($B$2:$B$14=$I5,ROW($D$2:$D$14)-1,\"\"),(COLUMN(K4)-\"9\")/1 ),0),\"\")","v":"10-10240"},{"$f":"IFERROR(OFFSET($D$1,SMALL(IF($B$2:$B$14=$I5,ROW($D$2:$D$14)-1,\"\"),(COLUMN(L4)-\"9\")/1 ),0),\"\")","v":""},{"$f":"IFERROR(OFFSET($D$1,SMALL(IF($B$2:$B$14=$I5,ROW($D$2:$D$14)-1,\"\"),(COLUMN(M4)-\"9\")/1 ),0),\"\")","v":""}]
["2010-04-12",10040223,222,"10-2362","S-275",null,null,null,10040224,{"$f":"IFERROR(OFFSET($D$1,SMALL(IF($B$2:$B$14=$I6,ROW($D$2:$D$14)-1,\"\"),(COLUMN(J5)-\"9\")/1 ),0),\"\")","v":"10-2364"},{"$f":"IFERROR(OFFSET($D$1,SMALL(IF($B$2:$B$14=$I6,ROW($D$2:$D$14)-1,\"\"),(COLUMN(K5)-\"9\")/1 ),0),\"\")","v":"10-12364"},{"$f":"IFERROR(OFFSET($D$1,SMALL(IF($B$2:$B$14=$I6,ROW($D$2:$D$14)-1,\"\"),(COLUMN(L5)-\"9\")/1 ),0),\"\")","v":""},{"$f":"IFERROR(OFFSET($D$1,SMALL(IF($B$2:$B$14=$I6,ROW($D$2:$D$14)-1,\"\"),(COLUMN(M5)-\"9\")/1 ),0),\"\")","v":""}]
["2010-04-13",10040224,2475,"10-2364","S-275"]
["2010-04-14",10040225,237,"10-2281","S-903"]
["2010-06-08",10040221,500,"10-4560","S-275"]
["2010-06-09",10040222,8000,"10-9840","S-275"]
["2010-06-10",10040223,222,"10-10240","S-275"]
["2010-10-05",10040224,2475,"10-12364","S-275"]
["2010-10-06",10040225,237,"10-22281","S-903",null,null,"* no numeric data"]
["2010-10-07",10040221,265,"10-34560","S-275"]
[]
[]
[]
["OFFSET($D$1,SMALL(IF($B$2:$B$14=$I4,ROW($D$2:$D$14)-1,\"\"),(COLUMN(J1)-\"9\")/1 ),0)"]
[]
[]
["offset - simply helps us in  getting the value  from  a particualr cell reference",null,"like if I type",{"$f":"OFFSET($C$1,3,0)","v":265},"it will return the value from 3 rows below of same column",null,null,null,"check syntax or help menu"]
["SMALL(IF($B$2:$B$14=$I4,ROW($D$2:$D$14)-1,\"\"),(COLUMN(J1)-\"9\")/1 "]
["small","small function will return the  values in ascending order from ",null,{"$f":"SMALL(C2:C14,1)","v":222},"IT IS THE SMALLEST VALUE IN COL C"]
[]
["IF($B$2:$B$14=$I4,ROW($D$2:$D$14)-1,\"\")"]
["If Function Is Doing Over Here Its Returing The Row No Where Value Of \"I2\" Matches In Col B"]
["As It Is Array Function It Will Keep On Returing The Row No One By One Till He Finds In Array"]
[]
[]
["NOW I CAN GET ALL THE MATCHING ROW NO ONE BY ONE USING IF FUNCTION FROM ARRAY SO WE HAVE TO PUT CONDITONS LIKE small(value, 1), small( value 2)"]
[null,"(COLUMN(J1)-\"9\")/1 "]
[]
[]
[null,"so for getting these numbers 1, 2, 3 etc"]
[]
[null,{"$f":"(COLUMN(J3)-\"9\")/1","v":1},{"$f":"(COLUMN(K3)-\"9\")/1","v":2}]
[null,"column j3 is 10  so 10-9","column k3 is 11-9 = 2","so it will keep on increasing"]
[]
[]
[null,"and use can use above in small function to return first smallestvalue  then second smallest value"]

{"sheet":"Sheet2","index":1,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["name","numerics",null,"name","numeric 1","numeric 2","numeric 3","numeric 4","numeric 5"]
["Raju                 ",45,null,"Raju                 ",{"$f":"IFERROR(SMALL(IF($A$1:$A$6=$D2,$B$1:$B$6),COLUMN(E1)-4),\"\")","v":45},{"$f":"IFERROR(SMALL(IF($A$1:$A$6=$D2,$B$1:$B$6),COLUMN(F1)-4),\"\")","v":45},{"$f":"IFERROR(SMALL(IF($A$1:$A$6=$D2,$B$1:$B$6),COLUMN(G1)-4),\"\")","v":96},{"$f":"IFERROR(SMALL(IF($A$1:$A$6=$D2,$B$1:$B$6),COLUMN(H1)-4),\"\")","v":""}]
["Raju                 ",96,null,"Kamal            ",{"$f":"IFERROR(SMALL(IF($A$1:$A$6=$D3,$B$1:$B$6),COLUMN(E2)-4),\"\")","v":25},{"$f":"IFERROR(SMALL(IF($A$1:$A$6=$D3,$B$1:$B$6),COLUMN(F2)-4),\"\")","v":87},{"$f":"IFERROR(SMALL(IF($A$1:$A$6=$D3,$B$1:$B$6),COLUMN(G2)-4),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A$1:$A$6=$D3,$B$1:$B$6),COLUMN(H2)-4),\"\")","v":""}]
["Kamal            ",87,null,null,{"$f":"IFERROR(SMALL(IF($A$1:$A$6=$D4,$B$1:$B$6),COLUMN(E3)-4),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A$1:$A$6=$D4,$B$1:$B$6),COLUMN(F3)-4),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A$1:$A$6=$D4,$B$1:$B$6),COLUMN(G3)-4),\"\")","v":""},{"$f":"IFERROR(SMALL(IF($A$1:$A$6=$D4,$B$1:$B$6),COLUMN(H3)-4),\"\")","v":""}]
["Raju                 ",45]
["Kamal            ",25]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"* numeric data"]

{"sheet":"Sheet3","index":2,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["name","numerics"]
["Kamal            ",87]
["Kamal            ",25]
["Raju                 ",45]
["Raju                 ",96]
["Raju                 ",45]
[]
[]
[]
[]
[null,"sort the data first on col basis"]