ÇóÖú£¬EXCEL2010½«ÎÞÐèÊý¾Ý×öÓÐÐòÌî³ä£¬ÈçͼËùʾ
WPSѧϰ¼¼ÇÉÖ®ExcelÖÐÈçºÎ¿ìËÙÅúÁ¿Ìî³äÓÐÐòÐòÁÐ - °Ù¶È¾Ñé
1 ÏÂÃæÎÒÃǾÍÑÝʾһÏÂÈçºÎ¿ìËÙÅúÁ¿µØÌî³äÕâ¸öÐòºÅµÄÊýÁаɣº2 ÔÚÆÕͨÇé¿öÏ£¬Ð¡±à¾³£Ë«»÷Õâ¸öСºì¿òÀï...
excelÖÐÓÐÐò»òÕßÌض¨Êý¾ÝµÄ¿ìËÙÌî³ä·½·¨ - °Ù¶È¾Ñé
2 ´ò¿ªÒ»¸öexcel±í¸ñ£¬ÈçͼËùʾ£¬ÔÚA2µ¥Ôª¸ñÖÐÊäÈëÕÅÈýµÄѧºÅ70301£¬È»ºóÓÃÊó±ê×ó¼üµ¥»÷A2µ¥Ôª¸ñ£¬°ÑÊó...
ÔõôÔÚexcelÖпìËÙÌî³äÓÐÐòÎı¾ÈçÓйæÂɵÄÊý×Ö - °Ù¶È¾Ñé
ÔõôÔÚexcelÖпìËÙÌî³äÓÐÐòÎı¾ÈçÓйæÂɵÄÊý×Ö,ÔÚÓÃexcel´¦ÀíÊý¾ÝµÄʱºò,³ýÁËÔÚ±í¸ñµÄÇ°ÃæÓÐÐòºÅ,×îÉÏÃæ...
excel±í¸ñÖÐÔõô¿ìËÙ¸ôÐÐÓÐÐòÌî³äÊý×Ö - ZOLÎÊ´ð
adve321 ÔÚB2ÊäÈ빫ʽ:=COUNTIF(A$2:A2,A2)ÏòÏÂÌî³ä¼´¿É ·¢²¼ÓÚ1993Äê12ÔÂ30ÈÕ ¾Ù±¨ Ïà¹ØÎÊÌâ ÔõôÑùÔÚ±í¸ñÖÐ×Ô¶¯Ìî³äÊý×ÖÐòºÅ ´ø¸ñʽµÄ...
Ôõô¶ÔExcel±í¸ñÖÐÄÚÈݽøÐÐÓÐÐòÅÅÁÐ?
1¡¢Ê×ÏÈ´ò¿ªÐèÒª½øÐÐÅÅÐòµÄ±í¸ñ£¬Èçͼ£¬ÕâÀïÒÔËæÒâÖÆ×÷µÄÒ»¸ö±í¸ñΪÀý£¬2¡¢È»ºóÔÚ¿ªÊ¼Ñ¡ÏÖÐÕÒµ½ÅÅÐòºÍɸѡѡ...
excelɸѡºóÈçºÎÌî³äÓÐÐòÊýÁÐ
ÔÚA1µ¥Ôª¸ñÊäÈëÒÔϹ«Ê½£¬È»ºóÏòÏÂÌî³ä¹«Ê½ =SUBTOTAL(3,B$1:B1)¹«Ê½±íʾ£º½«B$1:B1Öпɼûµ¥Ôª¸ñ...
excelÈí¼þÖÐ,Ôõô°ÑÒ»ÁÐÓÐÐòÊý×Ö¿ìËÙµÄÌî³äµ½,µ¥Ôª¸ñ...
1¡¢Ê×ÏÈ´ò¿ªÐèÒª±à¼µÄExcel±í¸ñ,µã»÷Îı¾¸ñʽµÄµ¥Ôª¸ñ¡£2¡¢È»ºóÊó±ê×ó¼ü360ÎÊ´ðµã»÷µ¥Ôª¸ñÓÒϽÇ...
excelÈçºÎÉú²úÓÐÐòÊý×Ö,²»ÊÇ¿Õ°×µ¥Ôª¸ñ
1¡¢ÔÚÈκÎλÖòåÈëÒ»¸ö¸¨ÖúÁУ¬×Ô¶¯Ìî³äÊý×Ö¡°ÐòºÅ¡±£¬Õâ¸öÐòºÅÊÇΪÁ˼Ǽϵ±Ç°µÄÊý¾ÝÅÅÐòµÄ 2¡¢¶Ô¹¤×÷...
EXCELÖÐÔÚÁ½ÐÐÖ®¼äµÄ¿Õ°×ÐÐÉÏÌî³äÓÐÐòÊý×Ö
Ñ¡ÖÐEÁУ¬°´CTRL+G£¬¡°¶¨Î»Ñ¡Ï£¬Ñ¡Ôñ¡°¿ÕÖµ¡±£¬È»ºóÔÚ¡°±à¼À¸¡±ÊäÈ빫ʽ£º=N(E1)+1 ×îºóCTRL+...
...¶àÐеıí¸ñ,ÏÂÀºó¶ÔӦλ×Ó¶¼ÄܽøÐÐÓÐÐòÌî³ä?
ÈçÏÂͼËùʾ£¬ÔÚ±àдºÃµÚÒ»¸öµ¥Ôª¸ñ¿ì¡°GHJ001¡±ºó£¬Ñ¡ÔñÕû¿éÏÂÀÌî³ä¿ÉÒԵõ½ÄãËùÐèÒªµÄµÄÈ«²¿Êý¾Ý£¬...