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

[µo°Ý] ¦p¦ó³]©w¦Û°Ê§ì¨ú³æ»ù

[µo°Ý] ¦p¦ó³]©w¦Û°Ê§ì¨ú³æ»ù

¤u§@»Ý­n¹ï»ù®æ,¦³®É«á·|¤£¤p¤ß¬Ý¿ù, ¤£ª¾¹DÀ³¸Ó«ç»ò³]©w¤~¯àÅý¹q¸£¦Û°Ê§P©w

QA.png
2021-2-23 17:14


¦Û°Ê§ì³æ»ù.rar (8.06 KB)
=)

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

°}¦C¤½¦¡:
=IFERROR(HLOOKUP(L3,VLOOKUP(K3,A:I,{2,4,6,8}+{0;1},),2),"")

¤p¤_¼Æ¶q1, ¨ú¦ó¼Æ???

TOP

¦^´_ 2# hcm19522


    hcm19522ª©¤j¤j:±z¦n!
    ·PÁªdªº¦^ÂÐ
     ´ú¸Õ ¦³¹J¨ì¤@¨Çª¬ªp  ¦A½Ð±zÀ°À°¦£!!!

QA1.png
2021-2-24 14:57

¦Û°Ê§ì³æ»ù1.rar (8.75 KB)
=)

TOP

¦^´_ 3# ­ã´£³¡ªL


  ·PÁ   ­ã´£³¡ªL ª©¤j¤jªº¦^ÂÐ
  ¤p©ó1¥i¥HÅã¥Ü"MOQ¤£¨¬" ¡A·PÁ±z~
  ³o­Ó¤w°ÝÃD·Q¤F«Ü¤[(¼g¤£¥X¨Ó><")¡Aª©¤j¤Ó¼F®`¤FXD
  «D±`·PÁÂ:loveliness:
=)

TOP

¦^´_ 4# ¤ýÏÉÏÉ


    =TEXT(MIN(IF((MOD(COLUMN(B:H),2)=0)*(B$3:H$9<=L3)*(A$3:A$9=K3)*(B$3:H$9<>""),C$3:I$9)),"0;;!MOQ¤£¨¬")
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 6# hcm19522


ÁÂÁ hcm19522 ¤j¤jªº¦^ÂСI
·PÁ±zµL¨pªº¤À¨É¡A¤S¾Ç¨ì¤F¥t¤@ºØ¤èªk¡A·P®¦¡I
=)

TOP

        ÀR«ä¦Û¦b : §Ñ¥\¤£§Ñ¹L¡A§Ñ«è¤£§Ñ®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD