- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
     
|
¦^´_ 7# eric7765
+ §ï¬° CÄæ ¬° "P"- Sub ±Æ¦C3()
- Range("D2:E999").ClearContents
- j = 1
- For i = 2 To [a65536].End(xlUp).Row
- If Cells(i, "C").Value = "P" Then
- 'For Each k In Array(123, 132, 213, 231, 312, 321)
- For k = 100 To 999
- a = Cells(i, "A")
- xA = 7 ^ Mid(a, 1, 1) + 7 ^ Mid(a, 2, 1) + 7 ^ Mid(a, 3, 1)
- xK = 7 ^ Mid(k, 1, 1) + 7 ^ Mid(k, 2, 1) + 7 ^ Mid(k, 3, 1)
- If xA = xK Then
- j = j + 1
- Cells(j, "D") = k
- Cells(j, "E") = Cells(i, "B")
- End If
- Next k
- Else
- j = j + 1
- Cells(j, "D") = Cells(i, "A")
- Cells(j, "E") = Cells(i, "B")
- End If
- Next i
- End Sub
½Æ»s¥N½X |
|