{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"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":"Лист1","index":0,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"хлеб","масло","батон","нож","икра"]
[]
[]
[null,null,null,"батон","масло"]
[]
[]
[]
[null,null,null,"Решение Gustav'а - жмём F9"]
[null,null,null,{"$f":"RANDBETWEEN(1,5)","v":4},{"$f":"LARGE(ISNA(MATCH(ROW($1:$5),$D10:D10,0))*ROW($1:$5),RANDBETWEEN(1,5-COUNT($D10:D10)))","v":2},{"$f":"LARGE(ISNA(MATCH(ROW($1:$5),$D10:E10,0))*ROW($1:$5),RANDBETWEEN(1,5-COUNT($D10:E10)))","v":3},{"$f":"LARGE(ISNA(MATCH(ROW($1:$5),$D10:F10,0))*ROW($1:$5),RANDBETWEEN(1,5-COUNT($D10:F10)))","v":5},{"$f":"SUM(ROW($1:$5))-SUM($D10:G10)","v":1}]
[null,null,null,{"$f":"INDEX($D$2:$H$2,D10)","v":"нож"},{"$f":"INDEX($D$2:$H$2,E10)","v":"масло"},"батон","икра","хлеб"]
[]
[null,null,null,"2-e решение Gustav'а - единая формула"]
[null,null,null,{"$f":"LARGE(ISNA(MATCH(ROW($1:$5),$C14:C14,0))*ROW($1:$5),RANDBETWEEN(1,5-COUNT($C14:C14)))","v":1},{"$f":"LARGE(ISNA(MATCH(ROW($1:$5),$C14:D14,0))*ROW($1:$5),RANDBETWEEN(1,5-COUNT($C14:D14)))","v":3},{"$f":"LARGE(ISNA(MATCH(ROW($1:$5),$C14:E14,0))*ROW($1:$5),RANDBETWEEN(1,5-COUNT($C14:E14)))","v":5},{"$f":"LARGE(ISNA(MATCH(ROW($1:$5),$C14:F14,0))*ROW($1:$5),RANDBETWEEN(1,5-COUNT($C14:F14)))","v":2},{"$f":"LARGE(ISNA(MATCH(ROW($1:$5),$C14:G14,0))*ROW($1:$5),RANDBETWEEN(1,5-COUNT($C14:G14)))","v":4}]
[null,null,null,{"$f":"INDEX($D$2:$H$2,D14)","v":"хлеб"},{"$f":"INDEX($D$2:$H$2,E14)","v":"батон"},"икра","масло","нож"]