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

[µo°Ý] »s§@½Ð±Ð

[µo°Ý] »s§@½Ð±Ð

ª¦¤F«Ü¦hÃö©óLOOKUP¡BMID¡BFIND©«¤å¤]¤£¹³³o­Ó»s§@¡A½Ð±Ð¦Ñ®v­Ì¥u¥Î³o¤T­Ó¨ç¼Æ¯à§_§¹¦¨³o­Ó»s§@¶Ü¡HÁÂÁ¤j®a Document.rar (6.28 KB)

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

TOP

¦^´_ 2# hcm19522
³o­¶­±03-04-09 14261·|­«½Æ¡A¤£·|¦³03-04-09 99999¥X²{¡C

TOP

¦^´_ 3# ²Â¤p«Ä
¨ú¤£­«½Æ 99999 ºâ¤£­«½Æ (¥t¥~¥[) ,§ï¦^¥h ,99999´N¤£¨£
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

ÁÙ®t¤@­Ó¨BÆJ«K§¹¦¨³o­Ó»s§@¡A¦A½Ð¦Ñ®v­Ì«ü±Ð¥Î¨º­Ó"¨ç¼Æ"¨Ï¿é¤J"­È"®É¤£»Ý­n¦b±ø¥ó¤@¡B¤G¤W¿é¤JªÅ®æ³Ì¦X¾A¡AÁÂÁÂ

»s§@.rar (8.28 KB)

TOP

¦^´_ 5# ²Â¤p«Ä

§Ú¤£ª¾¹D³oºØ°µªk¬O¤£¬O§A­nªº¡A
§Ú¥Îªº¬OMID,IF,IsNA,Vlookup,Countif,Countifs¡A
µ¹§A°Ñ¦Ò

Document.rar (46.61 KB)

TOP

¦^´_ 6# a5007185

¬Ý¬Ý³o­Ó·|§_Åý¦Ñ®v©ú¥Õ¤@ÂI

»s§@.rar (7.6 KB)

TOP

¦^´_ 7# ²Â¤p«Ä


    ¦pªG¤è«Kªº¸Ü¡A§Ú¥i¤£¥i¥H¥Îµu°T®§¸ò§A¸Ô²Ó¤F¸Ñ¤@¤U§Aªº»Ý¨D¡H

TOP

ÁÂÁÂa5007185¦Ñ®vÀ°§U§¹¦¨»s§@¡A¥u­n§â¡G

=LOOKUP(1,0/(J$1:J936=B28&B29&B30),L$1:L936)
§ï¦¨
=LOOKUP(1,0/(J$1:J936=B28&" "&B29&" "&B30),L$1:L936)
«K¯à§¹¦¨¡A¦Ûı¨S°÷¥Î¸£¡C

¦Ñ®vÁÙ§â§ÚªºÀÉ®×(231k)¥t°µ¤F¤@­Ó(88k)°e¤Fµ¹§Ú¡A¯uªº¶}¤ß©M·P°Ê¡C

- »s§@ (a5007185).rar (17.62 KB)

TOP

¦^´_ 8# a5007185
¦Ñ®v¥i§_¦AÀ°¦£­×§ï»s§@¡H¦³ªÅskype¨£¡AÁÂÁÂ

TOP

        ÀR«ä¦Û¦b : ¯¸¦b¥b¸ô¡A¤ñ¨«¨ì¥Ø¼Ð§ó¨¯­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD