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

[µo°Ý] Excel ­pºâ¤£­«½Æ¦¸¼Æ¡A¦p¦ó©¿²¤ªÅ¥ÕÄæ¦ì

{=SUM(IFERROR(1/COUNTIF(B:B,B11:B10000),))
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

{=SUM(IFERROR(1/COUNTIF(B:B,B2:B10000),)) ¤TÁä¤@°_«ö
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_  hcm19522
Ctrl +Shift +Enter

¦p¤Uµe­±
jsc0518 µoªí©ó 2022-2-20 17:39



    A11 §ï A2 ¸Õ¸Õ ~~~~
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : ª¾ÃÑ­n¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD