- ©«¤l
- 121
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 170
- ÂI¦W
- 57
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2021-1-21
- ³Ì«áµn¿ý
- 2024-6-3
|
¥»©«³Ì«á¥Ñ shuo1125 ©ó 2023-6-30 23:29 ½s¿è
¦^´_ 1# Andy2483
Andy¤j¦n!
µ{«×¦³..¶È¯à°w¹ï¤£¦P¶µ¥Ø½s§Ç,¬Ý¦³µL¨ä¥L°ª¤â¥X¤â!
Sub TEST()
Dim wSht As Worksheet, R&, i&, T$, N&
Set wSht = Sheets("¤u§@ªí1")
R = wSht.Cells(wSht.Rows.Count, "D").End(3).Row
For i = 2 To R
If wSht.Cells(i, 4).Value <> T Then
T = wSht.Cells(i, 4).Value
N = 1
End If
wSht.Cells(i, 5).Value = N
N = N + 1
Next i
End Sub |
|