ªð¦^¦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?
1.PNG
2020-2-12 21:30
2.PNG
2020-2-12 21:30

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?

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

TOP

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


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

TOP

¦^´_ 3# 013160


    =LOOKUP("®y",B:B)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

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®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD