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

[µo°Ý] ¦p¦ó§e²{¥XFILTER ¨ç¼Æªºµ²ªG?³]©w¦h­Ó籂¿ï±ø¥ó

[µo°Ý] ¦p¦ó§e²{¥XFILTER ¨ç¼Æªºµ²ªG?³]©w¦h­Ó籂¿ï±ø¥ó

¥»©«³Ì«á¥Ñ 013160 ©ó 2020-2-12 21:31 ½s¿è

³Ìªñª¾¹Doffice 360¦³°ÊºA°}¦C¨ç¼ÆFILTER¡A¤£ª¾¹D¦pªG¬O¤@¯ëoffice¬O§_Ãþ¦ü¨ç¼Æ¥i§e²{¬Û¦Pµ²ªG?

K¿é¤J²Ä¤@­Ó籂¿ï±ø¥ó ­ì¤lµ§
L¿é¤J²Ä¤G­Ó籂¿ï±ø¥ó ¤p¬ü
±o¥X§Ú¥þ³¡©ú²Ó¤¤¤p¬ü¦³³c°â­ì¤lµ§ªº­q³æ¬ÛÃö¸ê®Æ
¥t¥~·Q½Ð°Ý¦pªG§Ú·Q­n¥uÅã¥Ü¤p¬ü³c°â³Ì«á¤@µ§­q³æ¸ê®Æ¨ç¼ÆÀ³¸Ó¦p¦ó¼g?

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

hcm19522 µoªí©ó 2020-2-13 10:11


¨º¦pªG§Ú¥u­nÅã¥Ü³Ì«á¤@¦¸ªº¾P°â­q³æ©O?

TOP

¦^´_ 3# 013160


    =LOOKUP("®y",B:B)
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 4# hcm19522

§Ú¸Õ¸Õ¡AÁÂÁÂ~!

TOP

¥»©«³Ì«á¥Ñ zz5151353 ©ó 2021-9-8 14:30 ½s¿è

´£¨Ñ hcm19522¥Sªº¨Ò¤l¸ò³s±µ¸ô®|¨Ñ¤j®a°Ñ¦Ò
https://blog.xuite.net/hcm19522/twblog/588896375

¤]´£¨ÑOFFICE 365 ¸Ñªk ¸ò¦Û¤v¸Ñªk

´£¨Ñ°Ê±Þ±Ð¾ÇÀÉ®× S13.GIF (À£ÁYÀÉ®×)

OFFICE 365
  1. =FILTER(B2:E16,(C2:C16=K3)*(D2:D16=L3))
½Æ»s¥N½X
OFFICE 2003~2007
  1. =INDEX($B:$E,SMALL(IF(($C$2:$C$16=$K$3)*($D$2:$D$16=$L$3),ROW($2:$16),9999),ROW(1:1)),{1,2,3,4})
½Æ»s¥N½X

ZZ5151353.rar (7.77 KB)

S13.part1.rar (1 MB)

S13.part2.rar (1 MB)

S13.part3.rar (839.35 KB)

300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD