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

[µo°Ý] Âù±ø¥ó·j´M»PÁ`³~µ{¤½¦¡

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2021-6-13 16:36 ½s¿è

D2=LOOKUP(,0/((A2=³~µ{¸ê®Æ!A:A)*(B2=³~µ{¸ê®Æ!C:C)),COUNTIF(OFFSET(³~µ{¸ê®Æ!A$2,,,ROW($1:$1998)),³~µ{¸ê®Æ!A$2:A$1999))-1&"/"&COUNTIF(³~µ{¸ê®Æ!A:A,A2)

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

TOP

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD