DDE°ÊºA¸ê®Æ¦p¦ó¨Ï¥ÎHLOOKUP
- ©«¤l
- 13
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 18
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- HOME
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-10-25
- ³Ì«áµn¿ý
- 2023-8-18
|
DDE°ÊºA¸ê®Æ¦p¦ó¨Ï¥ÎHLOOKUP
¦bDDE°ÊºA¸ê®Æ¸Ì¡A¨C¤@¬q®É¶¡ªº¤À®É°O¿ý¡A¤À§Opºâ¥XMAXÈ¡A
¦ý¦³¿ìªk¬d§ä©Ò¹ïÀ³ªºÀx¦s®æ¶Ü¡H
¸Õ¤FLOOKUP¡BOFFSET¡BMATCH¡A³£¨S¿ìªk¦¨¥\¡A
¦n¹³n¯Â¼Æ¦r©Î¤å¦r¤~¯à¬d§ä¡A¸Ì±¦³¼g¤½¦¡ªº¸Ü¡A¤£ª¾¹D¦³¨S¦³¿ìªk....
DDE_LOOKUP.zip (67.71 KB)
|
|
|
|
|
|
|
- ©«¤l
- 13
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 18
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- HOME
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-10-25
- ³Ì«áµn¿ý
- 2023-8-18
|
¦^´_ 5# corcovado886
«á¨Ó¦Û¤v¶Ã¸Õ¸Ñ¨M¤F¡A¦bAAÄæ¥t¥~pºâMinÈ¡A
µM«á±N¦P¼Ëªº¤½¦¡½Æ»s¨ìABÄæ¡A©¹¤U¤@©Ô´Npºâ¥X¹ïÀ³È¤F¡C
¦ý³o¬O¹w¥ý¦b¨C¤@¦C¼g¦n¤½¦¡¡A¦³¨S¦³¿ìªk©T©wÅã¥Ü¦b¤@ÓÄæ¦ì©O¡H (¨Ò¦p Àx¦s®æY9) |
|
|
|
|
|
|
- ©«¤l
- 13
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 18
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- HOME
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-10-25
- ³Ì«áµn¿ý
- 2023-8-18
|
¦^´_ 4# hcm19522
·PÁ¤j®aªº¯d¨¥¡Aª©¤W¦n¦hexcel¤j®v ¡I
¦n¹³hcm19522 ¤j¤jªº¤~¬O¥¿¸Ñ¡A¦]¬°A10:V10 ¤£¤@©w¬O·Ó»¼¼W¶¶§Ç±Æ¦C¡C
¦pªGn¦bAA11Àx¦s®æ¥[¤WMinÈ©O¡H
¦]¬°¤½¦¡¦³ÂI½ÆÂø¡A¤£ª¾¹D«ç»ò±N¤U¦CªºMaxȧ令³Ì¤pÈ
=HLOOKUP(Y11,CHOOSE({1;2},OFFSET(A$10,ROW(A1),,,22),A$10:V$10),2,) |
|
|
|
|
|
|
- ©«¤l
- 1387
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1397
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-11-5
|
µwn¥ÎHLOOKUP °Ñ¦Ò
Z11=HLOOKUP(Y11,CHOOSE({1;2},OFFSET(A$10,ROW(A1),,,22),A$10:V$10),2,) |
|
|
|
|
|
|
- ©«¤l
- 2831
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2887
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-11-4
|
Z11:
=IF(COUNT(A11:V11),MATCH(Y11,A11:V11,),"") |
|
|
|
|
|
|
- ©«¤l
- 396
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 425
- ÂI¦W
- 1
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2013-7-2
- ³Ì«áµn¿ý
- 2024-8-23
|
¦^´_ 1# corcovado886
ª½±µ¼g¦bvba¸Ì±¥i¥H¶Ü¡H- Sub ¦Û°Ê°O¿ý()
- If uMode = 0 Then Exit Sub
- If Time > TimeValue(EndTime) Then '¦¬½L®É¶¡¥H«á¤£°õ¦æ
- Sht1.[W4] = "¤w¹L¦¬½L"
- uMode = 0
- Exit Sub
- End If
- Sht1.Range("W2") = Time '·í«e®É¶¡¡]®É¶¡½Xªí¡^
- '----------------------------------------------------------
- '¨C¢°¤ÀÄÁ°O¿ý¡A¢´¤ÀÄÁ«h§ï¬° Mod 5
- If Second(Time) Mod 3 = 0 Then
- xRow = Sht1.Range("A65536").End(xlUp).Row + 1
- If xRow < 11 Then xRow = 11
- Sht1.Range("A" & xRow & ":V" & xRow).Value = Sht1.Range("A2:V2").Value
- Sht1.Range("W" & xRow).Value = Time
- Mx = Application.Max(Sht1.Range("a" & xRow & ":v" & xRow))
- Sht1.Range("Y" & xRow).Value = Mx
- Ans = Sht1.Range("a" & xRow & ":v" & xRow).Find(Mx, , , xlWhole).Address
- Sht1.Range("Z" & xRow).Value = Range(Ans).Column
- '------------------------------------------------
- If ActiveSheet.Name = Sht1.Name And xRow > 20 Then
- ActiveWindow.ScrollRow = xRow - 12 'Åý³Ì·s¸ê®Æ«O«ù¦b¥i¨£µøµ¡¤¤
- End If
- ThisWorkbook.Save '¦sÀÉ
- End If
- Application.OnTime Now + TimeValue("00:00:01"), "¦Û°Ê°O¿ý" '¨C¤@¬í»¼°j¤@¦¸
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|