- ©«¤l
- 82
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 115
- ÂI¦W
- 0
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taipei
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2023-4-18
|
¥»©«³Ì«á¥Ñ mistery ©ó 2019-6-10 18:52 ½s¿è
¶]¤F¤T¦¸°j°é¡A¸ê®Æ¶q¤@¤j¡A·íµM·|¯Ó®É
«Øij¥ý"¿z¿ï",¦A±N¿z¿ï«áªºµ²ªG,Âà¨ì·JÁ`¥Îªº¤u§@ªí
³o¼ËÀ³¸Ó·|¤ñ¸û§Ö
(Ó¤H¦b³B²z¤W¦Ê¸Uµ§ªº¸ê®Æ¦³µo¥ÍÃþ¦üªº±¡§Î)(¦pªG¥i¥H,ª½±µ¥ÎACCESS ¤@©ì¤@©Ô¤ñ¸û§Ö)
¦]¬°¨S¦³ÀÉ®×, ºI¨ú¤@¬q"¿z¿ï"µ{¦¡½X·í°Ñ¦Ò
Rows("1:1").AutoFilter Field:=7, Criteria1:="XX«~¶µ", Operator:=xlFilterValues
Set FR = ActiveSheet.AutoFilter.Range.Columns(1).SpecialCells(xlCellTypeVisible)
For Each xR In FR
If xR.Row > 1 Then Cells(xR.Row, "I") =Application.WorksheetFunction.Subtotal(3, Range("A2:A" & Range("A1048576").End(xlUp).Row))
Next
Set FR = Nothing
Rows("1:1").AutoFilter |
|