指定年月 取唯一值 (10678)


G2{=INDEX(B:B,SMALL(IF((MATCH(TEXT(A$2:A$999,"YYYM")&B$2:B$999,TEXT(A$2:A$999,"YYYM")&B$2:B$999,)=ROW($1:$998))*(TEXT(A$2:A$999,"YYYM")=E$1&G$1),ROW(B$2:B$999),4^8),ROW(A1)))&""


留言