ÔõôÔÚexcelÖÐÈ¡·ÇÁã×îСֵ

¾Ù±¨ »Ø´ð
ÔõôÔÚexcelÖÐÈ¡·ÇÁã×îСֵ
ÎÊÔÚÏß¿Í·þ
ɨÂëÎÊÔÚÏß¿Í·þ

¼ÙÉè ÓÐA1£¬B2£¬C3£¬C4ÕâÑùËĸöµ¥Ôª¸ñ£¬ÎÒÏëÓÃÒ»¸öº¯ÊýʵÏÖÈ¡ÕâËĸöµ¥Ôª¸ñÖеķÇÁã×îСֵ£¬Ôõô×ö£

  • »Ø´ðÊý

    4

  • ä¯ÀÀÊý

    747

¾Ù±¨ »Ø´ð

4¸ö»Ø´ð ĬÈÏÅÅÐò
  • ĬÈÏÅÅÐò
  • °´Ê±¼äÅÅÐò

ûÕÒµ½ÂúÒâ´ð°¸£¿È¥Îʶ¹°üAIÖÇÄÜÖúÊÖ
È¡Ïû ¸´ÖÆÎÊÌâ
ÒѲÉÄÉ
ÒªÔÚExcelÖÐÈ¡·ÇÁã×îСֵ£¬¿ÉÒÔ°´ÕÕÒÔϲ½Öè½øÐвÙ×÷£º
1. Ê×ÏÈ£¬Ñ¡ÔñÄãÐèҪȡ·ÇÁã×îСֵµÄµ¥Ôª¸ñ·¶Î§¡£¼ÙÉèÎÒÃÇÒªÔÚA1¡¢B2¡¢C3ºÍC4ÕâËĸöµ¥Ôª¸ñÖÐÈ¡·ÇÁã×îСֵ£¬¿ÉÒÔʹÓÃÃû³Æ¿òÖеÄÊäÈëÀ´ÃüÃûËüÃÇ£¬ÀýÈ罫ÕâËĸöµ¥Ôª¸ñ·¶Î§ÃüÃûΪcheck¡£
2. Èç¹ûÕâЩµ¥Ôª¸ñÖÐÒѾ­°üº¬ÁËÊý×Ö£¬Ôò¿ÉÒÔʹÓÃÒÔϹ«Ê½À´È¡·ÇÁã×îСֵ£º
= LARGE(check, COUNTIF(check,"0")+COUNTIF(check,"0")+COUNTIF(check,"0")+COUNTIF(check,"0"))
Õâ¸ö¹«Ê½»á¸ù¾Ý¼ì²é·¶Î§ÄÚÊÇ·ñÓзÇÁãÊý¾ÝÀ´¼ÆËã³öËùÐèµÄ×îСֵ¡£
3. Èç¹ûÕâЩµ¥Ôª¸ñÖпÉÄÜ´æÔÚ¿Õµ¥Ôª¸ñ£¬Ôò¿ÉÒÔʹÓÃÒÔϹ«Ê½À´È¡·ÇÁã×îСֵ£º
= LARGE(check, COUNTIF(check,"0")+COUNTIF(check,"0")+COUNTIF(check,"0")+COUNTIF(check,"0")-COUNTBLANK(check)-COUNTBLANK(check)-COUNTBLANK(check)-COUNTBLANK(check))
Õâ¸ö¹«Ê½»á¸ù¾Ý¼ì²é·¶Î§ÄÚÊÇ·ñÓзÇÁãÊý¾ÝÒÔ¼°ÊÇ·ñ´æÔÚ¿Õ°×µ¥Ôª¸ñÀ´½øÐмÆË㣬²¢·µ»ØËùÐèµÄ×îСֵ¡£
ÒÔÉϾÍÊÇÔÚExcelÖÐÈ¡·ÇÁã×îСֵµÄ²½ÖèºÍÏà¹Ø¹«Ê½¡£Í¨¹ýÕâЩ·½·¨£¬Äã¿ÉÒÔÇáËɵػñÈ¡ËùÐèµÄ½á¹û¡£
È¡Ïû ÆÀÂÛ
ÓÒ»÷×Ý×ø±êÖᣬ¡°ÉèÖÃ×ø±êÖá¸ñʽ¡±£¬ÔÚ¡°×ø±êÖáÑ¡Ïҳ£¬¡°ºá×ø±êÖá½»²æ¡±£­£­¡°×ø±êÖáÖµ¡±£¬ÊäÈë×ÝÖá×îСֵ¡£
È¡Ïû ÆÀÂÛ
Óù滮Çó½â
È¡Ïû ÆÀÂÛ
ÍƲ»³öÀ´µÄ£¬ÒòΪÄãµÄδ֪ÊýÓÐÈý¸ö£¬¶øÌõ¼þÖ»ÓÐÁ½¸ö£¬ËùÒÔÊDz»ÐеÄ
È¡Ïû ÆÀÂÛ
ZOLÎÊ´ð > ÔõôÔÚexcelÖÐÈ¡·ÇÁã×îСֵ

¾Ù±¨

¸ÐлÄúΪÉçÇøµÄºÍг¹±Ï×Á¦Á¿ÇëÑ¡Ôñ¾Ù±¨ÀàÐÍ

¾Ù±¨³É¹¦

¾­¹ýºËʵºó½«»á×ö³ö´¦Àí
¸ÐлÄúΪÉçÇøºÍг×ö³ö¹±Ï×

ɨÂë²ÎÓëÐÂÆ·0ÔªÊÔÓÃ
ɹµ¥¡¢¶¥Â¥ºÀÀñµÈÄãÄÃ

ɨһɨ£¬¹Ø×¢ÎÒÃÇ
Ìáʾ

È·¶¨ÒªÈ¡Ïû´Ë´Î±¨Ãû£¬Í˳ö¸Ã»î¶¯£¿