在AA2:AT7建立輔助欄。AA2:=COUNTIF(A$2:F$7,A2)再將公式複製到AA2:AB7儲存格。AC2:=MAX(COUNTIF(C$2:H$7...
由於你沒有提供畫面或範例,我只能請你參考下列幾篇我的文章。https://ccenjor.pixnet.net/blog/post/2277006382107e...
AC1:=LARGE(IF(A2:A16<0,A2:A16,""),1)AD1:=LARGE(IF(A2:A16<0,A2:A1...
J2:=IFERROR(TEXT(A2,"m月d日")&"&"&TEXT(OFFSET(A2,M...
1.請在G3儲存格輸入公式:=IFERROR(IF(VLOOKUP(B3&" 合計",$B$3:$F$1000,5,0)="...
C1:=A1&TEXT(B1,"[=0]好")=CONCATENATE(A1,TEXT(B1,"[=0]好"))...