[B! excel][tips] hatayasanã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

hatayasan id:hatayasan

excelã¨tipsã«é–¢ã™ã‚‹hatayasanã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (15)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

EXCELã®ã€Œå½¢å¼ã‚’é¸æŠžã—ã¦è²¼ã‚Šä»˜ã‘ã€â†’ã€Œãƒ†ã‚ã‚¹ãƒˆã€ã¨ã„ã†ä½œæ¥ã‚’ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã§å‡ºæ¥ãªã„ã®ï¼Ÿ:ã‚¢ãƒ«ãƒ•ã‚¡ãƒ«ãƒ•ã‚¡ãƒ¢ã‚¶ã‚¤ã‚¯
ã€Œæ¢…ç”°ã«è¡Œã£ã¦åœ°ç„ã‚’è¦‹ã‚‹ã‹ã€å—æ¸¯ã«æ²ˆã‚ã‚‰ã‚Œã‚‹ã‹ã€ä»Šé‡‘ã‚’å‡ºã™ã‹ã€å¼·ç›—ï¼“äººçµ„ã‚’é€®æ• å¤§å¦ç”Ÿã‚’æ®´ã‚Šç¾é‡‘ã‚’å¥ªã†
hatayasan 2008/10/02
Altâ†’Eâ†’S ã‚’ãƒžã‚¯ãƒã§å‡¦ç†ã™ã‚‹æ–¹æ³•ã®ç´¹ä»‹ã€‚

2ch

excel

tips
ãƒªãƒ³ã‚¯
å››æ¨äº”å…¥,åˆ‡ã‚Šä¸Šã’,åˆ‡ã‚Šæ¨ã¦ã®é–¢æ•°ã®ä½¿ã„æ–¹(ROUND,ROUNDUP,ROUNDDOWN):Excelé–¢æ•°
ã€è§£ç”ä¾‹ã€‘ å¹³å‡ã¯AVERAGEé–¢æ•°ã‚’ä½¿ã„ã¾ã™ã€‚ å¹³å‡ã¯ã€€AVERAGE(C3:C8)ã§æ±‚ã‚ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ã“ã‚Œã‚’ROUNDé–¢æ•°ã®å¼•æ•°ã®æ•°å€¤éƒ¨åˆ†ã«å…¥ã‚Œã¾ã™ã€‚ C9ã‚»ãƒ«ã¯ã€å¹³å‡ç‚¹(æ•´æ•°)ã®C9ã‚»ãƒ«ã¯æ•´æ•°ã«ä¸¸ã‚ã‚‹ã®ã§ã€æ¡æ•°ã¯ 0 ã¨ã—ã¾ã™ã€‚ ã‚ˆã£ã¦ã€=ROUND(AVERAGE(C3:C8),0) C10ã‚»ãƒ«ã¯ã€å¹³å‡ç‚¹(å°æ•°ç¬¬1ä½)ã®C10ã‚»ãƒ«ã¯å°æ•°ç‚¹ä»¥ä¸‹1æ¡ã§ä¸¸ã‚ã‚‹ãŸã‚ã€æ¡æ•°ã‚’ 1 ã¨ã—ã¾ã™ã€‚ =ROUND(AVERAGE(C3:C8),1)ã¨ãªã‚Šã¾ã™ã€‚ 5æ¨6å…¥ã®è¨ˆç®—ã€€ã€€ã€€ã€€ã€€topã¸ ã€Œ5ã€ã¯åˆ‡ã‚Šæ¨ã¦ã¦ã€Œ6ã€ã‹ã‚‰åˆ‡ã‚Šä¸Šã’ã‚‹å ´åˆã¯ã€3é€šã‚Šã®æ–¹æ³•ãŒè€ƒãˆã‚‰ã‚Œã¾ã™ã€‚ è©²å½“æ¡æ•°ã®å€¤ã‚’ã€Œ-1ã€ã—ã¦ã€å››æ¨äº”å…¥ã™ã‚‹(ROUNDé–¢æ•°ã‚’ä½¿ã†) ï¼š=ROUND(B2-1,-1) è©²å½“æ¡æ•°ã®å€¤ã«ã€Œ4ã€åŠ ãˆã¦ã€åˆ‡ã‚Šæ¨ã¦ã™ã‚‹(ROUNDDOWNé–¢æ•°ã‚’ä½¿ã†)ï¼š=ROUNDDOWN(B2+4,-1) è©²å½“æ¡æ•°ã®å€¤ã‚’
hatayasan 2008/05/25
ã‚¨ã‚¯ã‚»ãƒ«ã®å››æ¨äº”å…¥é–¢æ•°ã¾ã¨ã‚ã€‚æ€ã£ãŸä»¥ä¸Šã«æ·±ã„ã€‚

excel

tips

summary
ãƒªãƒ³ã‚¯
Excelãƒ‡ãƒ¼ã‚¿ã‚’ãƒ“ã‚¸ãƒ¥ã‚¢ãƒ©ã‚¤ã‚ºã—ã‚ˆã† - DesignWalker
hatayasan 2008/04/12
REPTé–¢æ•°ã§ãƒ‡ãƒ¼ã‚¿ã‚’è¦–è¦šåŒ–ã§ãã‚‹ã€‚

excel

Tips
ãƒªãƒ³ã‚¯
ã‚¨ã‚¯ã‚»ãƒ«ã‹ã‚‰å¸³ç¥¨å½¢å¼ã«å·®è¾¼å°åˆ·ã—ãŸã„ã®ã§ã™ãŒ
ï¼ƒï¼ï¼‘ã§ã™ã€‚å‡ºè¡€å¤§ã‚µãƒ¼ãƒ“ã‚¹ã§ã™(^^; ãŸã ã—ä¸å…·åˆä»¥å¤–ã®ä¿®æ£ã¯ã”è‡ªèº«ã§ãŠé¡˜ã„ã—ã¾ã™ã€‚ ï¼’è¡Œç›®ï½žï¼”è¡Œç›®ã¨é …ç›®ã®å®šç¾©ã®ç®‡æ‰€ã¯å†åº¦è¨å®šã—ç›´ã—ã¦ãã ã•ã„ã€‚ Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) Sub InsPrint() Const org As String = "Sheet1" 'å…ƒãƒ‡ãƒ¼ã‚¿ã®ã‚·ãƒ¼ãƒˆå Const prs As String = "Sheet2" 'å°åˆ·ã™ã‚‹ã‚·ãƒ¼ãƒˆå Const strt As Integer = 2 'å…ƒãƒ‡ãƒ¼ã‚¿ã®å®Ÿãƒ‡ãƒ¼ã‚¿é–‹å§‹è¡Œ Dim idx, fromL, toL As Long Dim oSht, pSht As Worksheet Dim res, res2 Set oSht = Worksheets(org) Set pSht = Worksheets(prs)
hatayasan 2008/04/11
Excelã§å·®ã—è¾¼ã¿å°åˆ·ã€‚ä¸å¯§ãªãƒžã‚¯ãƒã®è§£èª¬ãŒã‚ã‚‹ã€‚

excel

Tips
ãƒªãƒ³ã‚¯
ã‚¨ã‚¯ã‚»ãƒ«ã§ã™ã€‚ã‚·ãƒ¼ãƒˆï¼‘ã®ãƒ‡ãƒ¼ã‚¿ã‚’ã‚·ãƒ¼ãƒˆï¼’ã¸é¡§å®¢æ¯Žã«å·®ã—è¾¼ã¿å°åˆ·ã—ãŸã„ã®ã§ã™ãŒã€ã©ã®ã‚ˆã†ãªãƒžã‚¯ãƒã«ã™ - ã‚¨ã‚¯ã‚»ãƒ«ã§ã™ã€‚ã‚·ãƒ¼ãƒˆï¼‘ã®ãƒ‡ãƒ¼ã‚¿... - Yahoo!çŸ¥æµè¢‹
ã‚¨ã‚¯ã‚»ãƒ«ã§ã™ã€‚ ã‚·ãƒ¼ãƒˆï¼‘ã®ãƒ‡ãƒ¼ã‚¿ã‚’ã‚·ãƒ¼ãƒˆï¼’ã¸é¡§å®¢æ¯Žã«å·®ã—è¾¼ã¿å°åˆ·ã—ãŸã„ã®ã§ã™ãŒã€ã©ã®ã‚ˆã†ãªãƒžã‚¯ãƒã«ã™ ã‚¨ã‚¯ã‚»ãƒ«ã§ã™ã€‚ ã‚·ãƒ¼ãƒˆï¼‘ã®ãƒ‡ãƒ¼ã‚¿ã‚’ã‚·ãƒ¼ãƒˆï¼’ã¸é¡§å®¢æ¯Žã«å·®ã—è¾¼ã¿å°åˆ·ã—ãŸã„ã®ã§ã™ãŒã€ã©ã®ã‚ˆã†ãªãƒžã‚¯ãƒã«ã™ã‚Œã°ã‚ˆã„ã®ã‹æ•™ãˆã¦ãã ã•ã„ã€‚ ç§ãƒžã‚¯ãƒåˆå¿ƒè€…ã§ã™ã®ã§èª¬æ˜Žã‚’æ·»ãˆã¦ã‚‚ã‚‰ãˆã‚Œã°ã†ã‚Œã—ã„ã§ã™ã€‚ ï¼ˆã‚·ãƒ¼ãƒˆï¼‘ï¼‰ãƒ‡ãƒ¼ã‚¿ãŒå…¥ã£ã¦ã„ã‚‹ã‚·ãƒ¼ãƒˆã§ã™ã€‚ è¡Œ åˆ—A åˆ—B åˆ—C åˆ—D åˆ—E 1 ã‚³ãƒ¼ãƒ‰ æ°å å•†å“å æ•°é‡ é‡‘é¡ 2 0001 AAAA S0001 10 1000 3 0001 AAAA S0002 20 4000 4 0002 BBBB S0001 50 5000 5 0002 BBBB S0003 30 9000 6 0002 BBBB S0004 10 4000 7 0003 CCCC S0001 50 5000 8 0004 DDDD S0002 30 6000 9 0004 DDDD S0
hatayasan 2008/04/11
Excelã ã‘ã§å·®ã—è¾¼ã¿å°åˆ·ã‚’å®Ÿç¾ã€‚ãƒžã‚¯ãƒã®çŸ¥è˜ãŒå¿…è¦ã€‚

excel

tips
ãƒªãƒ³ã‚¯
ã‚¨ã‚¯ã‚»ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’è¦‹ã‚„ã™ãã™ã‚‹5ã¤ã®ç°¡å˜ãªãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ | ã‚³ãƒªã‚¹
Chandoo.orgã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã‹ã‚‰ã€æ¡ä»¶ä»˜ãæ›¸å¼ã‚’åˆ©ç”¨ã—ã¦ã€ã‚¨ã‚¯ã‚»ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’è¦‹ã‚„ã™ãã™ã‚‹5ã¤ã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ Learn Cool Microsoft Excel Conditional Formatting Tricks ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ¨ªåˆ—ãƒ»ç¸¦åˆ—ã‚’ãƒã‚¤ãƒ©ã‚¤ãƒˆ æ¡ä»¶ä»˜ãæ›¸å¼ã‚’ä½¿ç”¨ã—ãŸã‚¬ãƒ³ãƒˆãƒãƒ£ãƒ¼ãƒˆ ã‚»ãƒ«å†…ã«é…ç½®ã™ã‚‹ã‚°ãƒ©ãƒ• ãƒŸã‚¹ã‚„ã‚¨ãƒ©ãƒ¼ãƒ»ãƒ‡ãƒ¼ã‚¿æ¬ è½ãªã©ã®ãƒã‚¤ãƒ©ã‚¤ãƒˆè¡¨ç¤º ç›´æ„Ÿçš„ã«æŠŠæ¡ã§ãã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ†ãƒ¼ãƒ–ãƒ« [ad#ad-2] ã‚¨ã‚¯ã‚»ãƒ«ãƒ‡ãƒ¼ã‚¿ã¯ã€Chandoo.orgã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®ä¸€ç•ªä¸‹ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã¾ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ¨ªåˆ—ãƒ»ç¸¦åˆ—ã‚’ãƒã‚¤ãƒ©ã‚¤ãƒˆ ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’è¦‹ã‚„ã™ãã™ã‚‹ãŸã‚ã«ã€æ¨ªåˆ—ãƒ»ç¸¦åˆ—ã‚’äº¤äº’ã«ãƒã‚¤ãƒ©ã‚¤ãƒˆè¡¨ç¤ºã«ã—ã¾ã™ã€‚ ãƒã‚¤ãƒ©ã‚¤ãƒˆã«ã™ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«å…¨ä½“ã‚’é¸æŠžã—ã¾ã™ã€‚ ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‚ˆã‚Šã€[æ›¸å¼] - [æ¡ä»¶ä»˜ãæ›¸å¼] ã‚’é¸æŠžã€‚ ã€Œæ•°å¼ã€ã‚’é¸æŠžã—ã€ã€Œ=MOD(ROW(),2)=0ã€ã‚’å…¥åŠ›ã—
hatayasan 2008/03/19
ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆé€²è¡Œè¡¨ã‚’æ¡ä»¶ä»˜æ›¸å¼ã‚’ä½¿ã£ã¦ã‚¹ãƒžãƒ¼ãƒˆã«ä»•ä¸Šã’ã‚‹ãƒ†ã‚¯ãªã©ã€‚/2000usersè¶…ãˆã¾ã™ã‹ã€‚

excel

Tips
ãƒªãƒ³ã‚¯
åˆå¿ƒè€…ãŒä½¿ã£ã¦ã¯ã„ã‘ãªã„ã‚¨ã‚¯ã‚»ãƒ«ã®5æ©Ÿèƒ½: å•“è’™ã‹ã¾ã¨ã¨æ–°èž
HN:LSTYï¼ˆã‚¨ãƒ«ã‚¨ã‚¹ãƒ†ã‚£ãƒ¼ãƒ¯ã‚¤ï¼‰ â–¡åå‰ã®ç”±æ¥ å¹´é½¢ï¼šã»ã¼50æ³ã€€æ€§åˆ¥ï¼šç”· â– è¶£å‘³ï¼šè‘—ä½œç‰©å…¨èˆ¬ã®é‘‘è³žãƒ»é£²é…’ â– ã„ã‚‰ã¡ãƒ»ã„ã¡ã³ã‚Šãƒ»ã„ã‚‰ã‚“ã“ã¨ã„ã„ â– ã»ã—ã„ã‚‚ã®ãƒªã‚¹ãƒˆ â– ã“ã“ä»¥å¤–ã®æ´»å‹•å ´æ‰€ Twitter: LSTYpt3 â€»ãŸã¾ã«éžå…¬é–‹ã«ã™ã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ é›‘è«‡ã¨æœ¬æ£š : Twitcasting YouTube : Gavacho Music SBM : å°ã•ãªãƒˆã‚«ã‚²å±• Novel : å°èª¬å®¶ã«ãªã‚ã† â– è»¢è¼‰ã«ã¤ã„ã¦ï¼šç§ãŒæ›¸ã„ãŸæ–‡ç« ã¯ã™ã¹ã¦è»¢è¼‰è‡ªç”±ã§ã™ãŒã€å‡ºå…¸ã®æ˜Žè¨˜ãŠã‚ˆã³ãƒªãƒ³ã‚¯ã‚’ãŠé¡˜ã„ã—ã¾ã™ã€‚ â– ã‚³ãƒ¡ãƒ³ãƒˆã«ã¤ã„ã¦ï¼šåå‰(ãƒãƒ³ãƒ‰ãƒ«ãƒãƒ¼ãƒ å«ã‚€)ã‚’ æ˜Žè¨˜ã—ã¦ã„ãªã„ã¨æ€ã‚ã‚Œã‚‹ã‚³ãƒ¡ãƒ³ãƒˆã«ã¯åŽŸå‰‡ã¨ã—ã¦å›žç”ã—ã¦ãŠã‚Šã¾ã›ã‚“ã€‚ å®£ä¼ç›®çš„ã ã¨åˆ¤æ–ã—ãŸå ´åˆã€ã¾ãŸè¨˜äº‹ã¨ç„¡é–¢ä¿‚ã ã¨åˆ¤æ–ã—ãŸå ´åˆã€å‰Šé™¤ã™ã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ ç§ã‚ã‚‹ã„ã¯ç¬¬ä¸‰è€…ã®å€‹äººæƒ…å ±ã‚„å€‹äººã‚’ç‰¹å®šã§ãã‚‹ã‚ˆã†ãªæƒ…å ±ãŒå«ã¾ã‚Œã¦ã„ã‚‹å ´åˆã€è©²å½“éƒ¨
hatayasan 2007/07/30
ã‚»ãƒ«çµåˆã‚’å–„æ„ã§ã‚„ã‚‹äººã¯å¤šã„ã§ã™ãã€‚

excel

Tips
ãƒªãƒ³ã‚¯
Office TANAKA-Excel
èª°ã§ã‚‚å¿…ãšãƒžã‚¯ãƒãŒ"èªã‚ã‚‹"ã‚ˆã†ã«ãªã£ã¦"æ›¸ã‘ã‚‹"ã‚ˆã†ã«ãªã‚‹ã€ŒVBAãƒ™ãƒ¼ã‚·ãƒƒã‚¯ã€ã¯ã€ã™ã¹ã¦ã®Excelãƒ¦ãƒ¼ã‚¶ãƒ¼ã«å—è¬›ã—ã¦ã„ãŸã ããŸã„ã§ã™ã€‚ã»ã‹ã«ã‚‚ã€æ•°å¤šãã®ã‚»ãƒŸãƒŠãƒ¼ã‚’å®Ÿæ–½ã—ã¦ã„ã¾ã™ã€‚æœ€ã‚‚é‡è¦ãªã“ã¨ã¯èª°ãŒæ•™ãˆã‚‹ã‹ã¨ã„ã†ã“ã¨ã§ã™ã€‚
hatayasan 2007/05/29
Excel2007ã®è§£èª¬ã€‚

excel

Tips

reference
ãƒªãƒ³ã‚¯
ã¡ã‚‡ã£ã¨è¦šãˆã¦ãŠãã¨ä¾¿åˆ©ãªExcelã®ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆ5ã¤ | P O P * P O P
Excelã‚’ã‚ˆãåˆ©ç”¨ã™ã‚‹æ–¹ã¯è¦šãˆã¦ãŠãã¨ä¾¿åˆ©ãªã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã®ã”ç´¹ä»‹ã€‚ã¡ã‚‡ã£ã¨çŸ¥ã£ã¦ã„ã‚‹ã ã‘ã§æ ¼æ®µã«ä½œæ¥ã‚¹ãƒ”ãƒ¼ãƒ‰ãŒé€Ÿããªã‚‹ã“ã¨ã‚‚ã€‚TechJiveã‹ã‚‰ã®æƒ…å ±ã§ã™ã€‚ Â» Excel Keystrokes ï¼ˆvia TechJiveï¼‰ ã€ŒCtrl+Spaceã€ :ãã®åˆ—å…¨ä½“ã‚’é¸æŠžã€‚ ã€ŒShift+Spaceã€ :ãã®è¡Œå…¨ä½“ã‚’é¸æŠžã€‚ ã€ŒCtrl+çŸ¢å°ã‚ãƒ¼ã€ :ãƒ‡ãƒ¼ã‚¿ãŒå…¥åŠ›ã•ã‚Œã¦ã„ã‚‹ç¯„å›²ã®å…ˆé è¡Œï¼ˆâ†‘ ï¼‰ã€æœ«å°¾è¡Œï¼ˆâ†“ï¼‰ã€å³ç«¯åˆ—ï¼ˆâ†’ï¼‰ã€å·¦ç«¯åˆ—ï¼ˆâ†ï¼‰ã«ç§»å‹•ã€‚ ã€ŒCtrl+Page Up/Page Downã€ :ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ¼ãƒˆé–“ã®ç§»å‹•ã€‚ ã€ŒCtrl+Homeã€ :ãã®ã‚·ãƒ¼ãƒˆã®A1ã®ã‚»ãƒ«ã¸ç§»å‹•ï¼ˆã‚¦ã‚£ãƒ³ãƒ‰ã‚¦æž ã‚’å›ºå®šã—ã¦ã„ã‚‹å ´åˆã¯ã€ãã®ä¸‹ã®ã‚»ãƒ«ï¼‰ã€‚ ã¡ãªã¿ã«å€‹äººçš„ã«ã‚ˆãä½¿ã†ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã¯ä»¥ä¸‹ã®ã‚ˆã†ãªã‚‚ã®ã§ã—ã‚‡ã†ã‹ã€‚ ã€ŒCtrl+1ã€ :ã‚»ãƒ«ã®æ›¸å¼è¨å®šã‚’é¸æŠžã€‚ ã€ŒShift+Enterã€ :ä¸Šã®è¡Œ/å·¦ã®åˆ—ã«ç§»å‹•ï¼ˆ
hatayasan 2007/02/23
ã€Œã€ŒAlt+Shift+=ã€ :ã‚ªãƒ¼ãƒˆSUMã‚’å®Ÿè¡Œã€ã¯çŸ¥ã‚‰ãªã‹ã£ãŸ

excel

tips
ãƒªãƒ³ã‚¯
Excelã§æ¨™æº–åå·®ã‚’æ±‚ã‚ã‚‹
Excelã§æ¨™æº–åå·®ã‚’æ±‚ã‚ã‚‹ Excelã§æ¨™æº–åå·®ã‚’æ±‚ã‚ã‚‹é–¢æ•°ã¯4ç¨®é¡žã‚ã‚Šã¾ã™ã€‚ æ¨™æº–åå·®ã‚’æ±‚ã‚ã‚‹ã«ã‚ãŸã£ã¦ã€å…¨ãƒ‡ãƒ¼ã‚¿ï¼ˆæ¯é›†å›£ï¼‰ã‚’è¨ˆç®—å¯¾è±¡ã«ã™ã‚‹å ´åˆã¯STDEVP.Pï¼ˆã‚¹ã‚¿ãƒ³ãƒ€ãƒ¼ãƒ‰ãƒ»ãƒ‡ã‚£ãƒ“ã‚¨ãƒ¼ã‚·ãƒ§ãƒ³ãƒ»ãƒ”ãƒ¼ï¼‰é–¢æ•°ã¾ãŸã¯STDEVPï¼ˆã‚¹ã‚¿ãƒ³ãƒ€ãƒ¼ãƒ‰ãƒ»ãƒ‡ã‚£ãƒ“ã‚¨ãƒ¼ã‚·ãƒ§ãƒ³ãƒ»ãƒ”ãƒ¼ï¼‰é–¢æ•°ã‚’ä½¿ã„ã¾ã™ã€‚ å¯¾è±¡ã®ãƒ‡ãƒ¼ã‚¿ã®ä¸€éƒ¨æŠœãå‡ºã—ãŸæ¨™æœ¬ã‚’è¨ˆç®—å¯¾è±¡ã«ã™ã‚‹å ´åˆã¯ã€STDEV.Sï¼ˆã‚¹ã‚¿ãƒ³ãƒ€ãƒ¼ãƒ‰ãƒ»ãƒ‡ã‚£ãƒ“ã‚¨ãƒ¼ã‚·ãƒ§ãƒ³ãƒ»ã‚¨ã‚¹ï¼‰ã¾ãŸã¯STDEVï¼ˆã‚¹ã‚¿ãƒ³ãƒ€ãƒ¼ãƒ‰ãƒ»ãƒ‡ã‚£ãƒ“ã‚¨ãƒ¼ã‚·ãƒ§ãƒ³ï¼‰é–¢æ•°ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ å…¨ãƒ‡ãƒ¼ã‚¿ã‚’è¨ˆç®—å¯¾è±¡ã¨ã—ã¦æ¨™æº–åå·®ã‚’æ±‚ã‚ã‚‹å ´åˆã¨æ¨™æœ¬ãŒè¨ˆç®—å¯¾è±¡ã€ãã‚Œãžã‚Œ2ã¤ã®é–¢æ•°ãŒã‚ã‚Šã¾ã™ã€‚Excelã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã‚ˆã‚‹é•ã„ã§ã™ã€‚Excel2007ä»¥å‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã¯ã€STDEVPã¨STDEVã‚’ä½¿ã„ã¾ã™ã€‚ Excel2010ä»¥é™ã§ã¯STDEV.Pã¨STDEV.Sã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ãªãŠã€Excelã®å¤ã„ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¨ã®äº’æ›æ€§ã‚’æŒãŸã›ã‚‹ãŸã‚
hatayasan 2006/09/06
Excelã§æ¨™æº–åå·®ã‚’å‡ºã™æ–¹æ³•

excel

Tips
ãƒªãƒ³ã‚¯
ã‚¨ã‚¯ã‚»ãƒ«æŠ€é“å ´
ã‚¨ã‚¯ã‚»ãƒ«æŠ€é“å ´ ã‚¨ã‚¯ã‚»ãƒ«ï¼ˆExcelï¼‰ã®åŠ¹çŽ‡çš„ãªä½¿ã„æ–¹ã€æ¡ä»¶ä»˜ãæ›¸å¼ãƒ»å…¥åŠ›è¦å‰‡ãªã©ã®æ©Ÿèƒ½ã‚’ã•ã‚‰ã«ä¾¿åˆ©ã«ä½¿ã„ã“ãªã™æŠ€ã€çµ„ã¿åˆã‚ã›ã¦ä½¿ã†é–¢æ•°ã®æŠ€ãªã©ã€ŒæŠ€ã€ã®æ•°ã€…ã‚’ç´¹ä»‹ã—ãŸãƒšãƒ¼ã‚¸ã§ã™ã€‚ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã‚ãƒ¼ã€ã‚¨ã‚¯ã‚»ãƒ«é–¢æ•°ã®èªã¿æ–¹ã¨èªžæºãƒªã‚¹ãƒˆãªã©ã®ä¾¿åˆ©ãªä¸€è¦§è¡¨ã‚‚ã‚ã‚Šã¾ã™ã€‚ ç¾åœ¨ã€ã‚¨ã‚¯ã‚»ãƒ«ã®æŠ€ã®ç·æ•°ã¯ç´„350ã§ã™ã€‚
hatayasan 2006/08/11
excel

tips
ãƒªãƒ³ã‚¯
i d e a * i d e a - Excelã§ã‚¦ãƒ«ãƒˆãƒ©ã‚·ãƒ³ãƒ—ãƒ«ãªã‚°ãƒ©ãƒ•ã‚’ä½œæˆã™ã‚‹æ–¹æ³•
ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä»£è¡¨ã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚°
hatayasan 2006/08/11
ä»Šåº¦è©¦ã—ã¦ã¿ã‚ˆã†ã€‚

excel

Tips
ãƒªãƒ³ã‚¯
ã‚¯ãƒªãƒƒãƒ—ã‚¢ãƒ¼ãƒˆã‚„ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆç´ æã®ç„¡æ–™ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰
ãƒ—ãƒªãƒ³ãƒˆã‚¢ã‚¦ãƒˆãƒ•ã‚¡ã‚¯ãƒˆãƒªãƒ¼ã®ã”åˆ©ç”¨ã«ã‚ãŸã£ã¦ã¯ãƒ–ãƒ©ã‚¦ã‚¶è¨å®šã§ã€Œã‚¯ãƒƒã‚ãƒ¼ã‚’å—ã‘ã¤ã‘ã‚‹ã€ã€ŒJavaScriptã‚’æœ‰åŠ¹ã«ã™ã‚‹ã€ã«ã—ã¦ãã ã•ã„ã€‚ ãƒ—ãƒªãƒ³ãƒˆã‚¢ã‚¦ãƒˆãƒ•ã‚¡ã‚¯ãƒˆãƒªãƒ¼ã«æŽ²è¼‰ã—ã¦ã„ã‚‹ç¤¾åã€å•†å“åã€å•†æ¨™ã€ã‚µãƒ¼ãƒ“ã‚¹ãƒžãƒ¼ã‚¯ãŠã‚ˆã³ãƒã‚´ã¯ã€å¼Šç¤¾ã¾ãŸã¯å„ç¤¾ã®ç™»éŒ²å•†æ¨™ãŠã‚ˆã³å•†æ¨™ã§ã™ã€‚
hatayasan 2006/04/03
free

excel

tool

Tips
ãƒªãƒ³ã‚¯
ã‚°ãƒ©ãƒ•ã®ç¨®é¡žã¨ãƒ‘ãƒ¼ãƒ„ã®åå‰
ä¸‹ã®ãƒ‡ãƒ¼ã‚¿ã‚’åŸºã«åˆ—ã‚’åŸºæº–ã«ã—ãŸç¸¦æ£’ã‚°ãƒ©ãƒ•ã‚’ä½œæˆã—ã¾ã™ã€‚ ã¾ãšã€æŠ˜ã‚Œç·šã‚°ãƒ©ãƒ•ã«å¤‰æ›´ã—ãŸã„ãƒ‡ãƒ¼ã‚¿ç³»åˆ—ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¾ã™ã€‚ ã‚°ãƒ©ãƒ•ãƒ„ãƒ¼ãƒ«ãƒãƒ¼ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã¯ï¼»ç³»åˆ—"åˆè¨ˆ"]ã«ãªã£ã¦ã„ã¾ã™ã€‚ å³ã‚¯ãƒªãƒƒã‚¯ã®ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‹ã‚‰ã€ï¼»ã‚°ãƒ©ãƒ•ã®ç¨®é¡žï¼½ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¾ã™ã€‚ ï¼»æ¨™æº–ï¼½ã‚¿ãƒ–ã‹ã‚‰ï¼»æŠ˜ã‚Œç·šï¼½ã‚°ãƒ©ãƒ•ã‚’é¸æŠžã—ã¦ã€ï¼»OKï¼½ãƒœã‚¿ãƒ³ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¾ã™ã€‚ æŠ˜ã‚Œç·šã‚°ãƒ©ãƒ•ã®è‰²ãŒæ°´è‰²ãªã®ã§ã€ç·šã®è‰²ã‚’å¤‰æ›´ã—ã¾ã™ã€‚ æŠ˜ã‚Œç·šã‚°ãƒ©ãƒ•ã‚’é¸æŠžã—ã¦ã€å³ã‚¯ãƒªãƒƒã‚¯ã®ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‹ã‚‰ï¼»ãƒ‡ãƒ¼ã‚¿ç³»åˆ—ã®æ›¸å¼è¨å®šï¼½ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¾ã™ã€‚ ï¼»ãƒ‘ã‚¿ãƒ¼ãƒ³ï¼½ã‚¿ãƒ–ã§ï¼»ç·šï¼½ã®ï¼»è‰²ï¼½ã¨ï¼»ãƒžãƒ¼ã‚«ãƒ¼ï¼½ã®ï¼»å‰æ™¯ï¼½ã®è‰²ã‚’å¤‰æ›´ã—ã¾ã™ã€‚ ãã—ã¦ã€ï¼»è»¸ï¼½ã‚¿ãƒ–ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¾ã™ã€‚ ï¼»ç¬¬2è»¸ï¼ˆä¸Š/å³å´ï¼‰ï¼½ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¾ã™ã€‚ã“ã‚Œã§ã€ä¸Šã®å›³ã¨åŒã˜ã‚°ãƒ©ãƒ•ã‚’ä½œæˆã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ç¬¬ï¼’è»¸ã®è¡¨ç¤ºã®æ–¹æ³•ã¯ã€ä»–ã«ã‚‚ã‚ã‚Šã¾ã™ã€‚ ä»¥ä¸‹ã®è¨˜äº‹ã§è§£èª¬ã—ã¦ã„ã¾ã™ã€‚ ã‚°ãƒ©ãƒ•ã®ç¬¬ï¼’è»¸ã®è¡¨ç¤º å‚è€ƒè¤‡
hatayasan 2006/01/26
Excelã§å°‘ã—è¶£å‘ã‚’å‡ã‚‰ã—ãŸã‚°ãƒ©ãƒ•ã‚’ä½œã‚‹ã¨ãã«å½¹ç«‹ã¤

Excel

tips
ãƒªãƒ³ã‚¯
å¹´é½¢ã‚’è¨ˆç®—ã™ã‚‹ï¼DATEDIFé–¢æ•°ï¼šExcel ã‚¨ã‚¯ã‚»ãƒ«ã®ä½¿ã„æ–¹-æ•°å¼/é–¢æ•°
å¹´é½¢ã‚„çµŒéŽæ—¥æ•°ãƒ»å‹¤ç¶šå¹´æ•°ã®è¨ˆç®—ã¨ã„ã†ã®ã¯æ¥å‹™ã®å†…å®¹ã«ã‚ˆã£ã¦ã¯é »ç¹ã«å‡ºã¦ãã‚‹ã®ã§ã€è¨ˆç®—æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¦ã„ã‚‹Webã‚µã‚¤ãƒˆã‚‚å°‘ãªãã‚ã‚Šã¾ã›ã‚“ã€‚ ã¨ã“ã‚ãŒãƒ¡ã‚¸ãƒ£ãƒ¼ãªã‚µã‚¤ãƒˆã§ã‚‚ã€é–“é•ã£ãŸæ–¹æ³•ã‚’ç´¹ä»‹ã—ã¦ã„ã‚‹ã“ã¨ãŒã‚ã‚‹ã®ã§æ³¨æ„ãŒå¿…è¦ã§ã™ã€‚ å˜ç´”ã«å¼•ãç®—ã‚’ã—ã¦ãƒ¦ãƒ¼ã‚¶ãƒ¼å®šç¾©æ›¸å¼ã§ã€Œyyæ³ã€ã¨è¨å®šã™ã‚Œã°OKã€ã¿ãŸã„ãªã“ã¨ã‚’æ›¸ã„ã¦ã‚ã‚‹ã‚µã‚¤ãƒˆãŒã‚ã‚‹ã®ã§ã™ãŒã€ã“ã‚Œã§ã¯ãƒ€ãƒ¡ã§ã™ã€‚ä»Šå¹´ã®è‡ªåˆ†ã®èª•ç”Ÿæ—¥ã‹ã‚‰ç”Ÿå¹´æœˆæ—¥ã‚’å¼•ã„ã¦ã¿ã‚Œã°ã™ãã«ã‚ã‹ã‚‹ã“ã¨ã§ã™ã€‚ã“ã®è¨ˆç®—å¼ã§ã¯èª•ç”Ÿæ—¥ã®æ¬¡ã®æ—¥ã«ãªã‚‰ãªã„ã¨å¹´é½¢ãŒåŠ ç®—ã•ã‚Œã¾ã›ã‚“ã€‚å¼•ãç®—ã‚’ã™ã‚‹ã¨ãã«èª¿æ•´ã‚’è¡Œã†å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚
hatayasan 2006/01/05
ã‚ˆãä½¿ã†æ©Ÿä¼šãŒã‚ã‚Šãã†ãªã®ã«æ„å¤–ã¨èº«ã«ã¤ã„ã¦ã„ãªã„æ©Ÿèƒ½ï¼Excelã®å¹´é½¢è¨ˆç®—

Excel

Tips
ãƒªãƒ³ã‚¯
1