'1. 可能是臨時 Key in 的關係, 欄A不是Excel的日期格式,
Sub 轉換為Excel日期格式()
Dim I As Integer, Ar
For I = 2 To Range("A" & Rows.Count).End(xlUp).Row
Ar = Split(Cells(I, 1), ".")
x = Trim(Str(Val(Ar(0)) + 1911)) & "/" & Ar(1) & "/" & Ar(2)
Cells(I, 1) = Trim(Str(Val(Ar(0)) + 1911)) & "/" & Ar(1) & "/" & Ar(2)
Next
End Sub
'2. 若 類別 長度一樣
Sub CountDist()
Dim Rng As Range, I As Integer, s1 As String, E
Set d = CreateObject("Scripting.Dictionary")
[F5:Q5] = "": [F9:Q9] = ""
Set Rng = Range([A2], "A" & Range("A" & Rows.Count).End(xlUp).Row)