{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Задание"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":21,"defined_names":308,"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":"Задание","index":0,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[15,0,20,0]]}
[]
["Дата (scolumn_maxdate)","Культура (scolumn)","Урожайность (scolumn_result)"]
["2015-12-08","ячмень",10]
["2015-12-08","пшеница",20]
["2015-07-06","ячмень",30]
["2015-04-08","пшеница",40]
["2015-08-27","пшеница",50]
["2015-12-09","гречиха",60]
["2015-03-22","гречиха",70]
["2015-09-09","гречиха",80]
[]
[]
[]
["Задача:",null,"Решение:"]
[]
["Из приведенной таблицы найти последнюю (самую позднюю) дату по выбранной культуре и вернуть значение из столбца \"Урожайность\".",null,"Культура (svalue)","Урожайность"]
[null,null,"гречиха",{"$f":"INDEX(C3:C10,MATCH(LARGE(IF(B3:B10=C17,A3:A10,\"\"),1)&C17,A3:A10&B3:B10,0))","v":60}]