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

[µo°Ý] ¦p¦ó¥Î¨ç¼Æ §ä¥X²Å¦X±ø¥ó¨Ã¶Ç¦^©Ò»Ýªº¸ê®Æ

[µo°Ý] ¦p¦ó¥Î¨ç¼Æ §ä¥X²Å¦X±ø¥ó¨Ã¶Ç¦^©Ò»Ýªº¸ê®Æ

¥»©«³Ì«á¥Ñ zheng211016 ©ó 2018-12-30 19:25 ½s¿è

½Ð¨D¦U¦ì¤j¯«~¤ä´©
·Q§Q¥Î¨ç¼Æ ±q¸ê®Æ°Ï(¹Ï¤ù¥ªÃä)¸Ì§ä¥X²Å¦XÁa¾î±ø¥ó(¹Ï¤ù¥kÃä)ªº¦ì¸m¨Ã¶Ç¦^¬Û¹ïÀ³ªºA¦C¸ê®Æ

¦p¤U¹Ï:
²Å¦X±ø¥óªº¬°B2 ,©Ò¥H¶Ç¦^A2ªº­È

2018-12-30_192001.jpg
2018-12-30 19:20


¨D½s¸¹.rar (6.79 KB)

¦^´_ 5# ­ã´£³¡ªL
¦^´_ 4# ML089
·PÁ¨â¦ì¤j¤jªº¤è¦¡ ³£¨S°ÝÃD ¤p§Ì¨ü¯q¨}¦h

TOP

=SUMPRODUCT((B$1:E$1=K4)*(B$2:E$5=J4)*A$2:A$5)
=INDEX(A:A,MATCH(J4,INDEX(A:E,,MATCH(K4,$1:$1,)),))

TOP

=INDEX(A:A,MATCH(J4,OFFSET(B:B,,MATCH(K4,$1:$1,)-2,),))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# hcm19522

¤£¦n·N«ä ¥i¯à¬O§Úªº±Ô­z¤£°÷¸Ô²Ó
§Ú¦A¸É¤Wµ²ªGªþ¹Ï
  
2019-01-01_183615.jpg
2019-1-1 18:36

TOP

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

TOP

        ÀR«ä¦Û¦b : ¹ï¤÷¥À­nª¾®¦¡A·P®¦¡B³ø®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD