{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["MINIF"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":"MINIF","index":0,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,7,26,10]]}
["Data",null,null,null,null,null,null,"1. MINIFS and MAXIFS since Office 2016"]
["Car type","Color","Price","Condition","Rank of price","Price if condition VW Golf is met",null,"Cheapest cars","Price","Color"]
["VW Golf","Red",15000,{"$f":"A3&\" \"&B3","v":"VW Golf Red"},{"$f":"IFERROR(RANK(F3,F:F,1),\"\")","v":1},{"$f":"IF(A3=\"VW Golf\",C3,\"\")","v":15000},null,"VW Golf",{"$f":"_xlfn.MINIFS(C:C,A:A,H3,B:B,J3)","v":{"$error":"#NAME?"}},"Blue"]
["Audi A3","Silver",20000,{"$f":"A4&\" \"&B4","v":"Audi A3 Silver"},"","",null,"Audi A3",{"$f":"_xlfn.MINIFS(C:C,A:A,H4,B:B,J4)","v":{"$error":"#NAME?"}},"Silver"]
["VW Golf","Blue",18000,"VW Golf Blue",2,18000,null,"Please note: Only works with Excel 2016 or newer"]
["VW Golf","Blue",22000,"VW Golf Blue",3,22000]
["Audi A3","Red",19000,"Audi A3 Red","","",null,"2. Workaround with IF and RANK and VLOOKUP"]
["Audi A3","Silver",21000,"Audi A3 Silver","","",null,"Cheapest cars","Price"]
[null,null,null,null,null,null,null,"VW Golf",{"$f":"VLOOKUP(1,E:F,2,FALSE)","v":15000}]
[]
[null,null,null,null,null,null,null,"3. Array Formula"]
[null,null,null,null,null,null,null,"Cheapest cars","Price","Color","Condition"]
[null,null,null,null,null,null,null,"VW Golf",{"$f":"MIN(IF(D:D=$K13,C:C))","v":18000},"Blue",{"$f":"H13&\" \"&J13","v":"VW Golf Blue"}]
[null,null,null,null,null,null,null,"Audi A3",{"$f":"MIN(IF(D:D=$K14,C:C))","v":20000},"Silver",{"$f":"H14&\" \"&J14","v":"Audi A3 Silver"}]
[]
[null,null,null,null,null,null,null,"4. Macro"]
[null,null,null,null,null,null,null,"Cheapest cars","Price","Color","Condition"]
[null,null,null,null,null,null,null,"VW Golf",{"$f":"PROFEXMinIfExample($C$3:$C$8,$D$3:$D$8,K18)","v":18000},"Blue",{"$f":"H18&\" \"&J18","v":"VW Golf Blue"}]
[null,null,null,null,null,null,null,"Audi A3",{"$f":"PROFEXMinIfExample($C$3:$C$8,$D$3:$D$8,K19)","v":20000},"Silver",{"$f":"H19&\" \"&J19","v":"Audi A3 Silver"}]
[]
[null,null,null,null,null,null,null,"5. Professor Excel Tools"]
[null,null,null,null,null,null,null,"Cheapest cars","Price","Color","Condition"]
[null,null,null,null,null,null,null,"VW Golf",{"$f":"[1]!PROFEXMinIf($C$3:$C$8,$D$3:$D$8,K23)","v":18000},"Blue",{"$f":"H23&\" \"&J23","v":"VW Golf Blue"}]
[null,null,null,null,null,null,null,"Audi A3",{"$f":"[1]!PROFEXMinIf($C$3:$C$8,$D$3:$D$8,K24)","v":20000},"Silver",{"$f":"H24&\" \"&J24","v":"Audi A3 Silver"}]
[null,null,null,null,null,null,null,"Please note: Only works after downloading the Excel add-in \"Professor Excel Tools\". Download and try Professor Excel Tools for free"]