大发专业带回血导师

如题所述

第1个回答 2021-10-18
PERCENTILE−老师∗(զ:∼789’078‾63)…求′采‾纳  =TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",100)),COLUMN(A:A)*100-99,100))*1=TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",100)),COLUMN(A:A)*100-99,100))/1=TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",100)),COLUMN(A:A)*100-99,100))^1 =--TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",100)),COLUMN(A:A)*100-99,100))=VALUE(TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",100)),COLUMN(A:A)*100-99,100))) =IF(O2="",YEAR(P2)-21,YEAR(P2)-24) =IF(O2="",YEAR(P2)-24,YEAR(P2)-21) =YEAR(P2)-IF(O2="",21,24) =YEAR(P2)-IF(O2="",24,21) =YEAR(P2)-21-(O2="")*3 =YEAR(P2)-24+(O2="")*3 =SUMPRODUCT((A$2:A$3=M8)*(ISNUMBER(B$2:K$3))*(B$2:K$3>0))-SUMPRODUCT((A$2:A$3=M8)*(ISNUMBER(B$2:K$2))*(ISNUMBER(B$3:K$3))*(B$2:K$3>0))/2
第2个回答 2021-10-18
JIS∼老师„(զ:…789″078–63)…求„采⋅纳‾=SUMPRODUCT((A2:A14<>"")*(B2:B14<>"")*(IFERROR(1/COUNTIFS(A2:A14,"<>",B2:B14,"<>",C2:C14,C2:C14),0)))=SUM(IF((A2:A14<>"")*(B2:B14<>""),1/COUNTIFS($C$2:$C$14,C2:C14,A2:A14,"<>"&"",B2:B14,"<>"&"")))。。(1)COUNTIF(B3:D8,B3:D8) =TEXT(MIN(IFERROR(--VLOOKUP(T(IF({1},C4:D4)),{"","9:0";"","14:0";"","8:0";"","10:0"},2,),1)),"hh:mm")&"-"&TEXT(MAX(IFERROR(--VLOOKUP(T(IF({1},C4:D4)),{"","19:0";"","22:0";"","18:0";"","18:0"},2,),-1)),"hh:mm")Function zhaozhi(a As Range, b As Range, Optional ByVal c As String = ",")For i = 1 To a.Rows.CountIf b.Cells(i, 1) =INDEX($C1:$AI1,SMALL(IF((COUNTIF($C1:$AI1,$C1:$AI1)=MAX(COUNTIF($C1:$AI1,$C1:$AI1)))*(MATCH($C1:$AI1,$C1:$AI1,)