Sub find_K_in_C2I()Dim arr()Sheets("工作表1").SelectRcnt = [a1].End(xlDow...
試試(結果放DE欄)Sub 巨集1()rA = Range("A1").End(xlDown).RowRange("A1:A&qu...
試試 C欄輸入=IF(SUM(IF(RIGHT(B1,1)*1=$A$1:$A$4,1,0)),"有","無")用陣列公...
在C1輸入=IFERROR(INDEX(A:A,SMALL(IF(IFERROR(FIND("甲",A:A,1),0),ROW(A:A),&...
假設時間在A欄(時間為同一天)將時間格式設定為hh:mm:ss如18:00需顯示為18:00:00在B欄將A欄時間更改為數字(B欄格式為通用)公式為=INT(A...
Sub 巨集1()T1 = NowRange("C2:C3").NumberFormatLocal = "yyyy/mm/dd h...
用VBA試試Sub 巨集1()k = 0RowCnt = Cells(65535, 1).End(xlUp).Row - 1ColCnt = Cells(1,...
jasonh的鐵人檔案