感谢导师对自己的帮助

如题所述

第1个回答 2021-10-18
VARPA 导师″(զ:∗789„078∗63)˜精‎凖‌计划∗ =IF(COUNTIFS(A$2:A2,G2,B$2:B2,H2)=1,C2,"") =SUMIFS(D:D,A:A,G2,B:B,H2,C:C,I2) =TEXTJOIN("、",TRUE,IF(C2:C3000>2000,B2:B300,""))=TEXTJOIN("、",TRUE,IF((A2:A3000>=F10)*(A2:A3000=2000),B2:B3000,"")) =VLOOKUP(C2,SHEET2!A:B,2,) =INDEX(SHEET2!B:B,MATCH(C2,SHEET2!A:A,)) =COUNTIF(OFFSET(Sheet1!$A12,,,1,MATCH(MAX(Sheet1!12:12),Sheet1!12:12,)),"=")