#author("2023-12-10T12:25:27+00:00","","") 配列数式 =TEXTJOIN(",", TRUE, IF(P2:P23<>99999, P2:P23, "")) #author("2023-12-10T12:32:28+00:00","","") 配列数式~ =TEXTJOIN(", ", 1, IF(P3:P23<>99999, TEXT(P3:P23, "0"), ""))~ cntl+shift+enter