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

[µo°Ý] ¤£¦P«È¤á¤U³æ¼t§O²Î­p

[µo°Ý] ¤£¦P«È¤á¤U³æ¼t§O²Î­p

¥Ø«e¦³¤T­Ó¼t¡A«È¤H¦³¤U³æµ¹A¡Bµ¹AB¡Bµ¹ABC¡K¡K¤£µ¥¡A¦p¤U¹Ï
data.jpg
2016-4-3 19:22


¦ÑÁó§Æ±æ¯àª½±µ¬Ý¥X«È¤H¦b­þ­Ó¼t¦³¤U³æ¡A¦p¤U¹Ï
µ²ªG.jpg
2016-4-3 19:22


¦]¬°¨C­Ó¤ë³£­n­«¶]¡A¥B¸ê®Æªñ3000~5000µ§¡A«È¤H¤]¤£¤@©w¨C­Ó³£³£·|¦b¦U­Ó¼t§O¤U³æ¡A©Ò¥H¤]»Ý­n¨C­Ó¤ë­«·s´£¨Ñ¦p¤U¹Ïªºªí®æµ¹¦ÑÁó¡C


½Ð°Ý¦³¨S¦³¤°»ò¤èªk©Î¬O¨ç¼Æ¡K¡Kµ¥¡A¥i¥H¸û§Ö³t§¹¦¨ªí®æ¡H

ÁÂÁ¡C
´ú¸ÕÀɦp¤U
DATA-test.zip (9.72 KB)

¦^´_ 1# mikan

¹³³o¼Ë¡H
DATA-test.rar (10.39 KB)

TOP

¤£¤j¬Û¦P¡A¦]¬°¤£¬O­n­pºâª÷ÃB¡A¥u¬O­nª¾¹D«È¤H¤U³æ¨ì­þ´X­Ó¼t¡A¦pµo°Ýªº²Ä¤G±i¹Ï¡A¤£»Ý­n¦Cª÷ÃB¡C

TOP

¦^´_ 3# mikan

¤£¦n·N«ä¡A§Ú¹ï¨ç¼Æ¤£¬ÆÁA¸Ñ
    ¨Ì¾Ú2¼Ó¤j¤jªº¤½¦¡¡A¥~¼h¦A¥[¤WIf  §PÂ_¤]¥i¥H¹F¦¨§Aªº­n¨D¡I

=IF(SUMIFS(DATA!$D$2:$D$31,DATA!$A$2:$A$31,LEFT(B$1,1),DATA!$C$2:$C$31,$A2)=0,"","V")

TOP

¦^´_ 2# tku0216
¦^´_ 4# lpk187

ÁÂÁ¨â¦ì¡A

TOP

=IF(SUMPRODUCT((DATA!$A$2:$A$31=LEFT(B$1))*(DATA!$C$2:$C$31=$A2)),"V","")

TOP

ÁÂÁ¤T¦ìªº¨ó§U¡C¡G¡^

¥Ø«e¹J¨ì¤@­Ó·s°ÝÃD¡Ð
±N¤½¦¡¥N¨ì¼Ï¯Ã®Ç¡A¦p¤U¡A«È¤á¦WºÙ®Ç·s¼W¤@Äæ«È¤á¥N½X¡C
0414-01.jpg
2016-4-14 16:29


¦ý¦b¼Ï¯Ãªí¤¤¡A§Æ±æ§e²{ªº¬O²Ä¤@Ä欰«È¤á¦WºÙ¡A²Ä¤GÄ欰«È¤á¥N½Xº¡¡A¦Ó«D²Ä¤@¦C¡B²Ä¤G¦C§e²{¡A¦p¤U¡Ð
0414-02.jpg
2016-4-14 16:32


½Ð°Ý¸Ó¦p¦ó§ï¤~¦æ¡HÁÂÁ¡C

DATA-test.zip (13.69 KB)

TOP

        ÀR«ä¦Û¦b : §Ú­Ì­n°µ¦nªÀ·|ªºÀô«O¡A¤]­n°µ¦n¤º¤ßªºÀô«O¡C
ªð¦^¦Cªí ¤W¤@¥DÃD