ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¦p¦ó¥ÎEXCEL¨ç¼Æ Åý¥¦ªí¹F¥X­þ­Ó¼Æ­È³Ì±µªñ ¬Y©T©w­È

¦bE4¦æ¶}©l°_¦h¤@­Ó  =ABS(D4-D$2)  ©Ô¤U¥h
µM«á®æ¦¡¤Æ±ø¥ó¥Î¤½¦¡ =RANK($E4,$E$4E$10,1)=1 ®M¥Î¨ì=$C$4C$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

TOP

¦^´_ 2# fengetianxia


  ªí±¡¬O":  $"

TOP

¦^´_ 4# ML089


    ¬Omin

­ì¨Ó®æ¦¡¤Æªº¤½¦¡¥i¥Hª½±µ¥Î¼Æ²Õ¤½¦¡.¨ü±Ð¤F

TOP

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD