ªð¦^¦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ªº­È



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

=MATCH(J4,B:B,)-1
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# hcm19522

¤£¦n·N«ä ¥i¯à¬O§Úªº±Ô­z¤£°÷¸Ô²Ó
§Ú¦A¸É¤Wµ²ªGªþ¹Ï
  

TOP

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

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

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

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD