依据编号提取日期列对应的最大日期

zhiwen20190717

依据编号提取日期列对应的最大日期.

jivy1212

1. =TEXTJOIN(",",1,TEXT(MAXIFS(C:C,B:B,MID(E2,{1,2,3}*5-4,4)),"e/m/d"))

复制代码

19以上支持。

博爱风雨同舟

=TEXTJOIN("、",,TEXT(INDEX(C:C,SMALL(IF(MAXIFS(C2:C7,B2:B7,B2:B7)=C2:C7,ROW(2:7),""),SEQUENCE(3))),"YYYY/MM/DD"))

无关岁月

1. =TEXTJOIN(",",,TEXT(MAXIFS(C:C,B:B,TEXTSPLIT(E2,",")),"e/m/d"))

复制代码

hugeinfo

=TEXTJOIN(",",,REDUCE("",TEXTSPLIT(E2,,","),LAMBDA(x,y,TEXT(VSTACK(x,TAKE(SORT(FILTER($C$2:$C$7,$B$2:$B$7=y),1,-1),1,1)),"e/m/d"))))

leepoison

=TEXTJOIN(",",,TEXT(XLOOKUP(TEXTSPLIT(E2,","),B2:B7,C2:C7,,,-1),"e/m/d"))

你是那块小饼干

1. =TEXTJOIN(",",TRUE,TEXT(REDUCE("",TEXTSPLIT(E2,,",",TRUE),LAMBDA(X,Y,VSTACK(X,XLOOKUP(Y,B2:B7,C2:C7,"",0,-1)))),"YYYY/MM/DD"))

复制代码

mykitami

=TEXTJOIN(",",,TEXT(MAP(TEXTSPLIT(E2,",",,1),LAMBDA(x,MAX(FILTER($C$2:$C$7,$B$2:$B$7=x)))),"e/m/d"))

秃头发师

=TEXTJOIN(",",TRUE,TEXT(MAXIFS(C2:C7,B2:B7,TEXTSPLIT(E2,,",")),"yyyy/m/d"))