¦p¦ó¥ÎEXCEL¨ç¼Æ Åý¥¦ªí¹F¥XþÓ¼Æȳ̱µªñ ¬Y©T©wÈ
- ©«¤l
- 49
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 92
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2001
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-4-10
- ³Ì«áµn¿ý
- 2024-8-9
|
¦p¦ó¥ÎEXCEL¨ç¼Æ Åý¥¦ªí¹F¥XþÓ¼Æȳ̱µªñ ¬Y©T©wÈ
¦p¦ó¥ÎEXCEL¨ç¼Æ Åý¥¦ªí¹F¥XþÓ¼Æȳ̱µªñ ¬Y©T©wÈ
Á|¨Ò
©T©wÈ 93
¼ÆÈ1 76
¼ÆÈ2 132
¦p¦ó¥ÎEXCEL¨ç¼Æ Åý¥¦ªí¹F¥XþÓ¼Æȳ̱µªñ©T©wÈ93 ¨Ã¥Î¶À¦â©³¦â¶ñº¡Àx¦s®æ
ªþ¹Ï»¡©ú
·PÁ¦U¦ì°ª¤âÀ°¦£ |
|
¾Ç²ß ¾Ç²ß ¤@ª½¾Ç²ß
|
|
|
|
|
- ©«¤l
- 93
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 134
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS7
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-3-21
- ³Ì«áµn¿ý
- 2020-11-30
|
¦bE4¦æ¶}©l°_¦h¤@Ó =ABS(D4-D$2) ©Ô¤U¥h
µM«á®æ¦¡¤Æ±ø¥ó¥Î¤½¦¡ =RANK($E4,$E$4 E$10,1)=1 ®M¥Î¨ì=$C$4 C$500
VBAªº¸Ü´N
Public Sub 钡()
k = Abs(Cells(4, 4) - Cells(2, 4))
For i = 4 To 500
a = Abs(Cells(i, 4) - Cells(2, 4))
If a < k Then
k = a
c = i
End If
Next
Cells(c, 3).Interior.ColorIndex = 6
End Sub |
|
|
|
|
|
|
- ©«¤l
- 93
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 134
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS7
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-3-21
- ³Ì«áµn¿ý
- 2020-11-30
|
¦^´_ 2# fengetianxia
ªí±¡¬O": $" |
|
|
|
|
|
|
- ©«¤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
![½×¾ÂºaÅA¾±³¹ ½×¾ÂºaÅA¾±³¹](images/common/medal14.gif) ![½×¾ÂÃÙ§U¾±³¹ ½×¾ÂÃÙ§U¾±³¹](images/common/medal3.gif) ![¼ö¯P°Ñ»P¾±³¹ ¼ö¯P°Ñ»P¾±³¹](images/common/medal7.gif) ![2014°¨¦~¥þ¶Ô¼ú³¹ 2014°¨¦~¥þ¶Ô¼ú³¹](images/common/ma.gif) ![2015¦Ï¦~¥þ¶Ô¼ú³¹ 2015¦Ï¦~¥þ¶Ô¼ú³¹](images/common/yang.gif) ![2016µU¦~¥þ¶Ô¼ú³¹ 2016µU¦~¥þ¶Ô¼ú³¹](images/common/hou.gif)
|
¥»©«³Ì«á¥Ñ ML089 ©ó 2016-4-12 20:18 ½s¿è
¦^´_ 1# peter95
C4 ®æ¦¡¤Æ¤½¦¡ =ABS($D$2-$D4)=MIN(ABS($D$4:$D$5-$D$2)) |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 93
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 134
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS7
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-3-21
- ³Ì«áµn¿ý
- 2020-11-30
|
¦^´_ 4# ML089
¬Omin
ì¨Ó®æ¦¡¤Æªº¤½¦¡¥i¥Hª½±µ¥Î¼Æ²Õ¤½¦¡.¨ü±Ð¤F |
|
|
|
|
|
|
- ©«¤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
![½×¾ÂºaÅA¾±³¹ ½×¾ÂºaÅA¾±³¹](images/common/medal14.gif) ![½×¾ÂÃÙ§U¾±³¹ ½×¾ÂÃÙ§U¾±³¹](images/common/medal3.gif) ![¼ö¯P°Ñ»P¾±³¹ ¼ö¯P°Ñ»P¾±³¹](images/common/medal7.gif) ![2014°¨¦~¥þ¶Ô¼ú³¹ 2014°¨¦~¥þ¶Ô¼ú³¹](images/common/ma.gif) ![2015¦Ï¦~¥þ¶Ô¼ú³¹ 2015¦Ï¦~¥þ¶Ô¼ú³¹](images/common/yang.gif) ![2016µU¦~¥þ¶Ô¼ú³¹ 2016µU¦~¥þ¶Ô¼ú³¹](images/common/hou.gif)
|
¦^´_ 5# fengetianxia
¦WºÙ¤½¦¡¡B®æ¦¡¤Æ¤½¦¡¥i¥Hª½±µ¥Î¼Æ²Õ¤½¦¡ |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|