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

[µo°Ý] Excel ¤À²Õ¤ÀÃþ¬y¤ô½X°ÝÃD

[µo°Ý] Excel ¤À²Õ¤ÀÃþ¬y¤ô½X°ÝÃD

¦U¦ì¥ý¶i¤j¤j¦n
¤p§Ì¦³¤@°ÝÃD(¨ç¼Æ)½Ð±Ð
¤@¯ë¬y¤ô½X³£¥ÎCOUNTIF ©ÎªÌ Sumproduct¥h¼g
¦ý¤p§Ìªº°ÝÃD¬O
AÄæ­«½Æ and BÄ椣­«½Æ ¬y¤ô½X+1
¦P¤W
­YAÄ椣­«½Æ BÄ椣ºÞ­«¤£­«½Æ ³£¥ý±q1¶}©l½s½X1
¦p¹Ï
ÂŦâ¬O¤p§Ì¼gªº¤½¦¡ ºñ¦â¬O¼Ð·Çµª®×
¥Î¤FÃþ¦üMax((IF)) offset  counif  counifs sumproduct  .....
©Ò¦³¦³Ãö¬y¤ô½Xªº¨ç¼Æ¥h¼g³£¼g¤£¥X¨Ó
Àµ½Ð½ç±Ð

¤p§Ìªþ¤WÀÉ®×
¬y¤ô½X.zip (8.82 KB)

=IF(COUNTIFS(A$2:A2,A$2:A2,B$2:B2,B$2:B2)=1,IFERROR(LOOKUP(1,0/(A$1:A1=A2),C$1:C1)+1,1),LOOKUP(1,0/(A$1:A1=A2)/(B$1:B1=B2),C$1:C1))
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

D2/°}¦C¤½¦¡:
=LOOKUP(9^9,IF({1,0},MAX(IF(A$1:A1=A2,D$1:D1))+1,LOOKUP(,0/(A$1:A1=A2)/(B$1:B1=B2),D$1:D1)))

TOP

¦^´_ 2# hcm19522


  ·PÁ hcm19522 ¤j ªº¨ó§U
¤p§Ì±N¤½¦¡®M¤J C2 ©¹¤U©Ô ¦ýµª®×¤£¹ï
ÁÙ¬O«ÜÁÂÁ±z

TOP

¦^´_ 3# ­ã´£³¡ªL

·PÁ ­ã´£³¡ªL ¤j
¦ý¬O¥i¯à¦³©Ò»~¸Ñ!!
¤p§Ì ­n¼gªº¤½¦¡ ¬O¥Î¦b CÄæ¦ì  ¦ý±zªº¬O¦bDÄæ¦ì
¤p§Ì¥Î¤F¤½¦¡¨Ã±N Dªº¤½¦¡§ï¦¨ C µª®×¤]¬O¤£¹ï
·PÁ±zªºÀ°¦£

TOP

¦^´_ 3# ­ã´£³¡ªL


    ­ã´£³¡ªL ¤j
©êºp!!­è­è¥Î¤F§Aªº¤½¦¡ ¦A°µ¤@¦¸½T»{
µª®×¬O¹ïªº !!
³y¦¨±zªº§xÂZ

¯à§_½ç±Ð!!½Ð°Ý ¤½¦¡¤¤ 9^9 ¥Nªí­þºØ·N«ä??
ÁÂÁÂ

TOP

¥»©«³Ì«á¥Ñ fantersy ©ó 2019-12-5 21:07 ½s¿è

¦^´_ 4# fantersy


    ©êºp¡I¡Ihcm19522¤j¤j
ªºµª®×¤]¬O¹ïªº¡I¡I
¬O¤p§Ìªº²¨©¿¡I¡I³y¦¨±z§xÂZ¡I©êºp

TOP

        ÀR«ä¦Û¦b : ¹D¼w¬O´£ª@¦Û§Úªº©ú¿O¡A¤£¸Ó¬O¨þ¥¸§O¤HªºÃ@¤l¡C
ªð¦^¦Cªí ¤W¤@¥DÃD