Weblog of S-ppc.com

ÀŲ¬»Ô¤Þ¤Á¤Å¤¯¤ê¸ø¼Ò¤Ã¤Æ²¿¤·¤Æ¤ë²ñ¼Ò¡©
<< March 2024 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 >>

¥é¥¤¥Ö¥¿¥¤¥ë¤Ë¾Ã¤·¤¿²èÁü¤¬É½¼¨¤µ¤ì¤Æ¤·¤Þ¤¦

¥Ô¥¯¥Á¥ã¡¼¥Õ¥©¥ë¥ÀÆâ¤Î²èÁü¤ò¾Ã¤·¤¿¤Î¤Ë¡¢

Windows¤Î¥Õ¥©¥È¤Î¥é¥¤¥Ö¥¿¥¤¥ë¤Ë¡¢

²èÁü¤¬É½¼¨¤µ¤ì¤Æ¤·¤Þ¤Ã¤Æ¤¤¤ë¤È¤¤¤¦

Ǻ¤ß¤ò¤ª»ý¤Á¤ÎÊý¤â¤¤¤é¤Ã¤·¤ã¤ë¤È»×¤¤¤Þ¤¹¡£

 

Æä˰ÛÆ°¤¬¤¢¤Ã¤¿¤ê¤Ç¡¢¥Ñ¥½¥³¥ó¤ò狼¤Ë°ú¤­·Ñ¤°¤È¤Ê¤ë¤È

¸Ä¿ÍŪ¤Ê¼Ì¿¿¤Ï¾Ã¤·¤Æ¤ª¤­¤¿¤¤¤â¤Î¤Ç¤¹¡£

 

https://121ware.com/qasearch/1007/app/servlet/qadoc?QID=019585

¾åµ­¥Û¡¼¥à¥Ú¡¼¥¸¤Ë¥é¥¤¥Ö¥¿¥¤¥ë¤Î

¥µ¥à¥Í¥¤¥ë¤òºï½ü¤¹¤ëÊýË¡¤¬½ñ¤¤¤Æ¤¢¤ê¤Þ¤¹¡£

»²¹Í¤Ë¤·¤Æ¤ß¤Æ²¼¤µ¤¤¡£

 

°ÛÆ°¤¹¤ëºÝ¡¢ËÜÅö¤Ï1Å٥ꥫ¥Ð¥ê¤·¤Æ¤«¤éPC¤ò°ú¤­·Ñ¤¤¤ÇÍߤ·¤¤¤Î¤Ç¤¹¤¬¤Í¡£

 

 

- | permalink | comments(0) | trackbacks(0)

Windows¡¡10¡¡Creators¡¡Update

Windows 10 Creators Update¤ò¤·¤Æ¤ß¤¿¤é¡¢

ÆüËܸì¤È±Ñ¸ì¤òÀÚ¤êÂؤ¨¤ë¤¿¤Ó¤Ë¡¢

Ãæ±û¤Ë¡Ö¤¢¡×¤È¤«¡ÖA¡×¤Èɽ¼¨¤µ¤ì¤ë¤è¤¦¤Ë¡¦¡¦¡¦

 

Èóɽ¼¨¤Ë¤¹¤ëÊýË¡¤òÄ´¤Ù¤¿¤Î¤Ç¡¢½ñ¤­¤Þ¤¹¡£

 

¤Þ¤º¡¢IME¤Î¥ª¥×¥·¥ç¥ó¤«¤é¥×¥í¥Ñ¥Æ¥£¤òÁª¤Ó¤Þ¤¹¡£

¡ÊÄ̾ï¤Ï²èÌ̱¦²¼¤Ë¤¢¤ë¡Ö¤¢¡×¤È¤«¡ÖA¡×¤ò±¦¥¯¥ê¥Ã¥¯¤Ç¡¢¥×¥í¥Ñ¥Æ¥£¡Ë

 

¼¡¤ËIMEÆþÎϥ⡼¥ÉÀÚÂؤÎÄÌÃΤȤ¤¤¦Éôʬ¤Î

²èÌÌÃæ±û¤Ëɽ¼¨¤¹¤ë¤Î¥Á¥§¥Ã¥¯¤ò³°¤·¤Þ¤¹¡£

 

°Ê¾å¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª

 

¤³¤ì¤Ç¤ï¤º¤é¤ï¤·¤¤É½¼¨¤¬¾Ã¤¨¤Þ¤·¤¿¥é¥Ã¥­¡¼

- | permalink | comments(0) | trackbacks(0)

¥Æ¡¼¥×µ¯¤³¤·¥×¥ì¥¤¥ä¡¼

¥Æ¡¼¥×µ¯¤³¤·ÍѤΥץ쥤¥ä¡¼¤¬ÌµÎÁ¤ÇÇÛÉÛ¤µ¤ì¤Æ¤¤¤¿¤Î¤Ç¡¢

¥À¥¦¥ó¥í¡¼¥É¤·¤Æ¤ß¤Þ¤·¤¿¡£

 

²ñµÄÏ¿¤òºî¤ëºÝ¤Ëʸ»úµ¯¤³¤·¤Ï¤è¤¯¤ä¤Ã¤Æ¤¤¤ë¤Î¤Ç¡¢

»È¤Ã¤Æ¤ß¤Æ¡¢¤Þ¤¿´¶ÁÛ¤ò½ñ¤­¤¿¤¤¤È»×¤¤¤Þ¤¹¡£

 

¼«Ê¬¤â¤è¤¯Ê¸»úµ¯¤³¤·¤ä¤Ã¤Æ¤¤¤ë¤è¤Ã¤ÆÊý¤Ï

²¼µ­¥Û¡¼¥à¥Ú¡¼¥¸¤«¤é¥À¥¦¥ó¥í¡¼¥É½ÐÍè¤Þ¤¹¤Î¤Ç¡¢

»È¤Ã¤Æ¤ß¤Æ¤Ï¤¤¤«¤¬¤Ç¤·¤ç¤¦¤«¡©

https://www.asca-voitex.jp/?p=1709

»¨ÃÌ | permalink | comments(0) | trackbacks(0)

¥Ñ¥½¥³¥ó¤ÎÃæ¿È¤ÎÂçÁݽü

¤½¤Î¥Ñ¥½¥³¥óÆ°ºî¤¬°­¤¯¤Ê¤¤¤Ç¤¹¤«¡©

 

Windows¤ÏŤ¯»ÈÍѤ·¤Æ¤¤¤ë¤È¡¢¸Å¤¤ÀßÄê¤ä»ÈÍѵ­Ï¿¤È¤¤¤Ã¤¿¥´¥ß¥Õ¥¡¥¤¥ë¤¬Î¯¤Þ¤ê¡¢Æ°ºî¤¬Æߤ¯¤Ê¤ê¤Þ¤¹¡£Æä˼«Ê¬¤Ç¥½¥Õ¥È¥¦¥§¥¢¤òÄɲ䷤Ƥ¤¤ë¾ì¹ç¤Ï¡¢ÀßÄ꤬¿¤¯¤Ê¤ë»ö¤«¤é¡¢Æ°ºî¤Ø¤Î±Æ¶Á¤âÂ礭¤¯¤Ê¤ê¤Þ¤¹¡£¤Þ¤¿¡¢¤½¤¦¤¤¤Ã¤¿¥½¥Õ¥È¤¬¼«Æ°¼Â¹Ô¤µ¤ì¡¢¥ê¥½¡¼¥¹¤ò¾ÃÈñ¤·¤Æ¤¤¤ë¾õÂ֤⿤¯¸«¼õ¤±¤é¤ì¤Þ¤¹¡£°ÛÆ°¤ÎºÝ¤Ï¡¢¼¡¤Î¿Í¤¬»È¤¤¤ä¤¹¤¤¤è¤¦¤Ë¡¢¤Ê¤ë¤Ù¤¯ºÇ¾®¸Â¤ÎÀßÄê¤ËÌᤷ¤Æ¤¢¤²¤Þ¤·¤ç¤¦¡£

 

¥ê¥«¥Ð¥ê¤ò¤¹¤ë¤½¤ÎÁ°¤Ë

  • ¥Ð¥Ã¥¯¥¢¥Ã¥×¤Ï¤È¤ê¤Þ¤·¤¿¤«¡©
  • Office¤äPhotoshopÅù¤òºÆ¥¤¥ó¥¹¥È¡¼¥ë¤¹¤ëºÝ¤Î¥·¥ê¥¢¥ë¤Ï¤¢¤ê¤Þ¤¹¤«¡©
  • ¥Í¥Ã¥È¥ï¡¼¥¯¤ÎÀßÄê¤ò¥á¥â¤·¤Þ¤·¤¿¤«¡©
  • ¥ê¥«¥Ð¥ê¥Ç¥£¥¹¥¯¤ÏºîÀ®¤·¤Þ¤·¤¿¤«¡©

 

¥Ð¥Ã¥¯¥¢¥Ã¥×¥Á¥§¥Ã¥¯¥ê¥¹¥È

  • ¥í¡¼¥«¥ë¥Õ¥¡¥¤¥ë¡Êʸ½ñ¡¢²èÁü¤Ê¤É¡Ë
  • ¥á¡¼¥ë¥Ç¡¼¥¿¡Ê¥¢¥É¥ì¥¹Ä¢¡¢ÀßÄê¤â¡Ë
  • ¥Ö¥é¥¦¥¶¤ÎÀßÄê¡Ê¤ªµ¤¤ËÆþ¤êÅù¡Ë
  • ¥Õ¥©¥ó¥È¡Ê¼«Ê¬¤ÇÄɲä·¤¿¤â¤Î¡Ë
  • ¤½¤Î¾¼«Ê¬¤Ç¥«¥¹¥¿¥Þ¥¤¥º¤·¤¿ÀßÄê¡Ê¥æ¡¼¥¶¡¼¼­½ñ¤Ê¤É¡Ë

 

¥ê¥«¥Ð¥ê¤ò¤·¤¿¤é

  • ¥·¥¹¥Æ¥à¤ÎÀßÄê¤ò¥Ñ¥Õ¥©¡¼¥Þ¥ó¥¹Í¥Àè¤Ë¤·¤è¤¦
  • ¥»¥­¥å¥ê¥Æ¥£¥½¥Õ¥È¤ò¥¤¥ó¥¹¥È¡¼¥ë¤·¤è¤¦
  • ¥Í¥Ã¥È¥ï¡¼¥¯¤ÎÀßÄê¤ò¤·¤è¤¦¡ÊNAS¡Ë
  • ¥×¥ê¥ó¥¿¤ÎÀßÄê¤ò¤·¤è¤¦
  • Office¤ò¥¤¥ó¥¹¥È¡¼¥ë¤·¤è¤¦
  • ¥á¡¼¥ë¤ÎÀßÄê¤ò¤·¤è¤¦

 

»¨ÃÌ | permalink | comments(0) | trackbacks(0)

ÂçÁݽü

ǯËö¤Ç¤¹¤Í¡£

¤³¤Î»þ´ü³§¤µ¤óÂçÁݽü¤ÇÂçË»¤·¤Ç¤·¤ç¤¦¤¬¡¢

¤½¤ó¤ÊÂçÁݽü¤Ç¤¼¤Ò¤ä¤Ã¤Æ¤¤¤¿¤À¤­¤¿¤¤¤Î¤¬¡¢

¥Ñ¥½¥³¥ó¤ÎÂçÁݽü¤Ç¤¹¡£

¥Ñ¥½¥³¥ó¤òÇã¤Ã¤Æ¤«¤é£±ÅÙ¤âÃæ¤ò³«¤±¤¿¤³¤È¤¬Ìµ¤¤

¤Ê¤ó¤Æ¿Í¤ÏÆäËÁݽü¤¹¤ë»ö¤ò¥ª¥¹¥¹¥á¤·¤Þ¤¹¡£

 

¥Ñ¥½¥³¥ó¡¡¤Û¤³¤ê¤Ç²èÁü¸¡º÷¤·¤Æ¤ß¤Æ²¼¤µ¤¤¡£

¿ôǯÁݽü¤·¤Æ¤¤¤Ê¤¤¥Ñ¥½¥³¥ó¤Ï¤¨¤é¤¤»ö¤Ë¤Ê¤Ã¤Æ¤¤¤ë

²ÄǽÀ­¤¬¹â¤¤¤Ç¤¹¡£

¤Û¤³¤ê¤¬Î¯¤Þ¤Ã¤¿¥Ñ¥½¥³¥ó¤ÏÇ®¤¬¤³¤â¤ê¡¢

Æ°ºî¤Ë»Ù¾ã¤ò¤­¤¿¤¹¾ì¹ç¤â¤¢¤ê¤Þ¤¹¤·¡¢

¤â¤Ã¤È¹ó¤¤¤È²õ¤ì¤Þ¤¹¡£

ºÇ°­¤Î¾ì¹ç²Ð»ö¤Ë¤Ê¤ê¤Þ¤¹¡£

 

¥Ç¥¹¥¯¥È¥Ã¥×¥Ñ¥½¥³¥ó¤Ç¤·¤¿¤é¡¢

ÁǿͤǤâ´Êñ¤Ë¥«¥Ð¡¼¤ò³°¤»¤Þ¤¹¤Î¤Ç¡¢

Áݽüµ¡¤ä¥À¥¹¥¿¡¼¤Ç¸«¤¨¤ëÉôʬ¤Î¤Û¤³¤ê¤ò½üµî¤·¤Æ²¼¤µ¤¤¡£

 

¥Î¡¼¥È¥Ñ¥½¥³¥ó¤òºÙÉô¤Þ¤ÇÀ¶Áݤ¹¤ë¤Î¤Ï¡¢

´·¤ì¤¿¿Í¤Ç¤Ê¤¤¤ÈÆñ¤·¤¤¤È»×¤¤¤Þ¤¹¡£

ÂçÄñ¤Î¥Ñ¥½¥³¥ó¤ÏCPU¥¯¡¼¥é¡¼Éôʬ¤Ë¤Û¤³¤ê¤¬Î¯¤Þ¤ê¤Þ¤¹¤Î¤Ç¡¢

¤½¤ÎÉôʬ¤À¤±¤ÏÁݽü¤·¤ä¤¹¤¤¤è¤¦¤ËÀ߷פµ¤ì¤Æ¤¤¤Þ¤¹¡£

ÇØÌ̤Υ«¥Ð¡¼¤ò³«¤±¤Æ¡¢¥À¥¹¥¿¡¼¤Ç¡¢CPU¤Î¥Õ¥¡¥ó¤ÎÉôʬ¤Î¤Û¤³¤ê¤ò½üµî¤·¤Æ²¼¤µ¤¤¡£

 

Áݽü¤¹¤ëºÝ¤Ë¡¢µ¤¤òÉÕ¤±¤Æ¤¤¤¿¤À¤­¤¿¤¤¤Î¤¬¡¢

ÀÅÅŵ¤¤Ç¤¹¡£¥Ñ¥½¥³¥ó¤ÎÉôÉʤˤϡ¢ÀÅÅŵ¤¤Ë¤È¤Æ¤â¼å¤¤¤â¤Î¤â¤¢¤ê¤Þ¤¹¡£

ÆäËÅߤÏÀÅÅŵ¤¤¬È¯À¸¤·¤ä¤¹¤¤¤Ç¤¹¤Î¤Ç¡¢ÆâÉô¤ò¿¨¤ëºÝ¤Ï

ɬ¤ºÊüÅŤ·¤Æ¤«¤é¤Ë¤·¤Æ²¼¤µ¤¤¡£

¤Þ¤¿¡¢CPU¥Õ¥¡¥ó¤Ï¤È¤Æ¤âÀºÌ©¤ÊÉôÉʤǤ¹¡£

±©¤òľÀÜ¿¨¤ë¤È¼´¤¬¶Ê¤¬¤Ã¤Æ¡¢²õ¤ì¤¿¤ê¤·¤Þ¤¹¡£

¥Õ¥¡¥ó¤Ë¤ÏľÀÜ¿¨¤é¤Ê¤¤¤è¤¦¤Ë¤·¤Æ¡¢

¤Ê¤ª¤«¤Ä¥À¥¹¥¿¡¼¤ò»È¤¦»þ¤âÃúÇ«¤Ë°·¤Ã¤Æ²¼¤µ¤¤¡£

Áݽü¤Ê¤Î¤Ç¥Ô¥Ã¥«¥Ô¥«¤Ë¤·¤¿¤¤¤È¤³¤í¤Ç¤¢¤ê¤Þ¤¹¤¬¡¢

̵Íý¤ò¤»¤º¡¢¤Û¤É¤Û¤É¤Ç½½Ê¬¤Ç¤¹¡£

 

¤Ê¤ó¤À¤«Ä¹¤¯¤Ê¤Ã¤Æ¤·¤Þ¤¤¤Þ¤·¤¿¤¬¡¢

£±Ç¯¤Ë£±ÅÙ¤°¤é¤¤¤Ï¥Ñ¥½¥³¥ó¤ÎÁݽü¤â¤·¤Æ¤¢¤²¤Æ²¼¤µ¤¤¡£

°Ê¾å¡¢¼¡²ó¤Ï¡¢¥Ñ¥½¥³¥ó¤ÎÃæ¿È¡Ê¥Ï¡¼¥É¥Ç¥£¥¹¥¯¤ÎÁݽüÊÔ¤ò¤ªÁ÷¤ê¤·¤Þ¤¹¡Ë

 

»²¹Í¥Û¡¼¥à¥Ú¡¼¥¸

https://matome.naver.jp/odai/2143970115634660101

http://www.pc2.jp/pc/mente/cleaning.htm

»¨ÃÌ | permalink | comments(0) | trackbacks(0)

¥¢¥ó¥±¡¼¥È½¸·×

±ØË̥ѡ¼¥­¥ó¥°¤Ç¼Â»Ü¤·¤¿¥¢¥ó¥±¡¼¥È¤Î½¸·×¤Ç¤¹¤¬¡¢

https://select-type.com/

¾åµ­¥µ¥¤¥È¤Î¥¢¥ó¥±¡¼¥È¥Õ¥©¡¼¥à¤òÍøÍѤ·¤Æ½¸·×¤·¤Þ¤·¤¿¡£

²óÅú¤Î°ìÍ÷¤òCSV¥Õ¥¡¥¤¥ë¤Ç¥À¥¦¥ó¥í¡¼¥É¤Ç¤­¤ë¤Î¤Ç¡¢¤È¤Æ¤âÊØÍø¤Ç¤¹¡£

 

¤¿¤À¤·¡¢Ãí°Õ»ö¹à¤¬¤¢¤ê¤Þ¤¹¡£

 

¤Þ¤º¡¢ÄɲýÐÍè¤ë¼ÁÌä¿ô¤Ï10¸Ä¤Þ¤Ç¤Ç¤¹¡£

¸Ä¿Í¾ðÊóÆþÎÏÍó¤ÏÊ̤ÇÀßÃÖ¤â½ÐÍè¤ë¤Î¤Ç¡¢

½»½ê¡¢À­ÊÌ¡¢Ç¯Îð¤È¤«¤Î¥Ç¡¼¥¿¤Ï¤½¤³¤ÇÆþÎϤ¹¤ë¤è¤¦¤Ë¤·¤Þ¤·¤¿¡£

¡Ê¤¿¤À¤·¡¢Ëè²ó¥¿¥¤¥Ô¥ó¥°¤·¤Æ¤ÎÆþÎϤˤʤê¤Þ¤¹¡Ë

 

¼¡¤Ë¡¢ÆþÎϤǤ­¤ë¥Ç¡¼¥¿¤Ï100·ï¤Þ¤Ç¤Ç¤¹¡£

¥Ç¥Õ¥©¥ë¥È¤ÎÀßÄê¤Ç¤Ï¡¢100·ï¤òĶ¤¨¤ë¤È

¼«Æ°Åª¤Ë¸Å¤¤¥Ç¡¼¥¿¤«¤é¾Ã¤¨¤Æ¤¤¤Ã¤Æ¤·¤Þ¤¤¤Þ¤¹¡£

²óÅúÀ©¸ÂÀßÄê¤È¤¤¤¦¤È¤³¤í¤Î

²óÅúÄùÀÚ¿ô¤ò100¤Ë¤·¤Æ¡¢

²óÅúÄùÀÚ¤ê¿ôĶ²á»þ¤Î½èÍýÊýË¡¤ò¥Õ¥©¡¼¥à¤òÄùÀÚ¤ë¤Ë¤·¤Þ¤¹¡£

¤³¤¦¤·¤Æ¤ª¤±¤Ð100·ï¤Þ¤Ç¤·¤«ÆþÎϤǤ­¤Þ¤»¤ó¤Î¤Ç¡¢

100·ïÆþÎϤ·¤¿¤é¡¢²óÅú°ìÍ÷¤«¤éCSV¥Õ¥¡¥¤¥ë¤ò¥À¥¦¥ó¥í¡¼¥É¤·¤Æ¤«¤é

²óÅú¥Ç¡¼¥¿¤òºï½ü¤·¤Æ¡¢¤Þ¤¿Ê̤Υǡ¼¥¿¤òÆþÎϤ¹¤ë¤è¤¦¤Ë¤·¤Þ¤¹¡£

 

¼ÁÌä¤ò²óÅúɬ¿Ü¤Ë¤·¤Æ¤ª¤±¤Ð¡¢ÆþÎÏϳ¤ì¤âËɤ²¤Þ¤¹¤·¡¢

CSV¥Õ¥¡¥¤¥ë¤Ç¥À¥¦¥ó¥í¡¼¥É¤¹¤ì¤Ð¸å¤«¤éʬÀϤ¹¤ë¤Î¤Ë¤âÊØÍø¤Ç¤¹¤Î¤Ç¡¢

¥ª¥¹¥¹¥á¤Ç¤¹¤è¡£

¤¿¤À¡¢¤â¤Ã¤ÈÎɤ¤¥µ¥¤¥È¤È¤«¤ä¤êÊý¤¢¤ë¤Ç¤·¤ç¤¦¤«¤é¡¢

ÃΤäƤëÊý¤Ï¤¼¤Ò¶µ¤¨¤Æ²¼¤µ¤¤¡£

 

 

»¨ÃÌ | permalink | comments(0) | trackbacks(0)

¥¯¥í¥¹½¸·×Ū¤Ê¤ä¤Ä

º£²ó¤Ï¡¢¥¢¥ó¥±¡¼¥È½¸·×·ë²Ì¤ò¥°¥é¥Õ²½¤¹¤ëºÝ¡¢¥Õ¥£¥ë¥¿¤ÇÃê½Ð¤·¤¿·ë²Ì¤òÈ¿±Ç¤µ¤»¤ëÊýË¡¤Ë¤Ä¤¤¤Æ½ñ¤­¤Þ¤¹¡£

 

¥¨¥¯¥»¥ë¤Î¥·¡¼¥È¤Ë¥¢¥ó¥±¡¼¥È¤Ç½¸¤á¤é¤ì¤¿¥Ç¡¼¥¿¤òÆþÎϤ¹¤ë¤Î¤Ç¤¹¤¬¡¢

Î㤨¤Ð²¼µ­¤Î¤è¤¦¤ËÆþÎϤµ¤ì¤¿¥·¡¼¥È¤¬¤¢¤Ã¤¿¤È¤·¤Þ¤¹¡£

AÎó¤ËÀ­Ê̤Υǡ¼¥¿¡ÊA1¤¬ÃËA2¤¬½÷A3¤¬Ãˤߤ¿¤¤¤Ê¡Ë

BÎó¤ËÃÏ°è¤Î¥Ç¡¼¥¿¡ÊB1¤¬ÅìµþÅÔB2¤¬ºë¶Ì¸©B3¤¬ÀéÍÕ¸©¤ß¤¿¤¤¤Ê¡Ë

CÎó¤Ë¹¥¤­¤Ê¥¹¥Ý¡¼¥Ä¤òÊ£¿ô²óÅú²Ä¡ÊC1¤¬Ìîµå ¥µ¥Ã¥«¡¼C2¤¬¥µ¥Ã¥«¡¼ C3¤¬¥µ¥Ã¥«¡¼ ¥Ð¥¹¥±¤ß¤¿¤¤¤Ê¡Ë

 

¤³¤¦¤¤¤Ã¤¿¥Ç¡¼¥¿¤Ç¥°¥é¥Õ¤òºî¤ë»þ¤Ë¡¢¤Þ¤º²ÝÂê¤È¤Ê¤ë¤Î¤¬¡¢Ê£¿ô²óÅú¤ÎÉôʬ¤Ç¤¹¡£

CÎó¤Ç¥µ¥Ã¥«¡¼¤ò½¸·×¤¹¤ëºÝ¡¢=countif(C1:C3,"¥µ¥Ã¥«¡¼")¤ÈÆþÎϤ¹¤ë¤È¡¢

C1¤ÎÌîµå ¥µ¥Ã¥«¡¼¤ÈC3¤Î¥µ¥Ã¥«¡¼ ¥Ð¥¹¥±¤ò¥«¥¦¥ó¥È¤·¤Æ¤¯¤ì¤Þ¤»¤ó¡£

 

¤½¤³¤Ç¡¢½¸·×¤¹¤ë¥»¥ë¤Ë=countif(C1:C3,"*¥µ¥Ã¥«¡¼*")¤È¤¤¤¦¤è¤¦¤Ë¡¢

¥ï¥¤¥ë¥É¥«¡¼¥É¤ò»È¤Ã¤Æ¥«¥¦¥ó¥È¤¹¤ì¤Ð¡¢C1¤âC3¤â¥«¥¦¥ó¥È¤·¤Æ¤¯¤ì¤Þ¤¹¡£

 

¤¿¤À¡¢ÅìµþÅÔ¤ÎÃËÀ­¤À¤±¤Î½¸·×¤ò¸«¤¿¤¤¤È»×¤¤¡¢¸µ¤Î¥Ç¡¼¥¿¤Ë¥Õ¥£¥ë¥¿¤ò¤«¤±¤Æ

ɽ¼¨¤·¤Æ¤â¡¢countif¤ÏÈóɽ¼¨¤ÎÉôʬ¤â¥«¥¦¥ó¥È¤·¤Æ¤·¤Þ¤¦¤Î¤Ç¡¢

½¸·×¥Ç¡¼¥¿¤Ë¤ÏÈ¿±Ç¤µ¤ì¤Þ¤»¤ó¡£

 

¥Õ¥£¥ë¥¿¤ò¤«¤±¤¿¾õÂÖ¤ò¥«¥¦¥ó¥È¤¹¤ë´Ø¿ô¤È¤·¤Æsubtotal¤È¤¤¤¦¤â¤Î¤¬¤¢¤ê¤Þ¤¹¤¬¡¢

¤³¤ì¤À¤ÈÆÃÄê¤Îʸ»ú¤òÃê½Ð¤·¤Æ¥«¥¦¥ó¥È¤¹¤ë»ö¤¬½ÐÍè¤Þ¤»¤ó¡£

 

¤½¤³¤Ç¡¢sumproduct´Ø¿ô¤ò»È¤¤

=SUMPRODUCT(SUBTOTAL(3,OFFSET(C1,ROW(INDIRECT("1:"&ROWS(C1:C3))),))*(C1:C3="¥µ¥Ã¥«¡¼"))

¤ß¤¿¤¤¤Êµ­½Ò¤ò¤·¤Æ¤ß¤¿¤Î¤Ç¤¹¤¬¡¢¤³¤Î¼°¤Ç¥µ¥Ã¥«¡¼¤ÎÁ°¸å¤Ë¥¢¥¹¥¿¥ê¥¹¥¯¤ò»È¤¦¤È¥«¥¦¥ó¥È¤µ¤ì¤Þ¤»¤ó¤Ç¤·¤¿¡£

 

·ë¶É¥Þ¥¯¥í¤ò»È¤Ã¤Æsubtotal_countif¤È¤¤¤¦¤â¤Î¤òÄêµÁ¤·¤Æ¥«¥¦¥ó¥È¤·¤Þ¤·¤¿¡£

°Ê²¼¤¬¤½¤Î¥Þ¥¯¥í¤Îµ­½Ò¤Ë¤Ê¤ê¤Þ¤¹¡£

 

Public Function subtotal_countif(rgSelect As Range, moji As String)
    Dim rg As Range '¥»¥ë
    Dim cot As Long '¥«¥¦¥ó¥¿

    For Each rg In rgSelect
        If Rows(rg.Row).Hidden = False Then 'ɽ¼¨¤µ¤ì¤Æ¤¤¤ë¹Ô¤À¤±Âоݤˤ¹¤ë
            If rg Like moji Then
                cot = cot + 1
            End If
        End If
    Next
    subtotal_countif = cot
 End Function

 

¥¨¥¯¥»¥ë¤ÎVBE¥á¥Ë¥å¡¼(ALT+F11)¤Ç¡¢ÁÞÆþ→ɸ½à¥â¥¸¥å¡¼¥ë¤ÇÁÞÆþ¤¹¤ì¤Ð

=subtotal_countif(ÈÏ°Ï,”*Ãê½Ðʸ»ú*”¡Ë¤È¤¤¤¦¼°¤¬»È¤¨¤ë¤è¤¦¤Ë¤Ê¤ê¤Þ¤¹¡£

¤³¤ì¤Ç¡¢¥Õ¥£¥ë¥¿¤ò¤«¤±¤¿¾õÂÖ¤ÇÆÃÄê¤Îʸ»ú¤òÃê½Ð¥«¥¦¥ó¥È¤¹¤ë»ö¤¬½ÐÍè¤ë¤è¤¦¤Ë¤Ê¤ê¡¢

¥°¥é¥Õ¤â¤½¤Î¥Õ¥£¥ë¥¿¤ò¤«¤±¤¿¾õÂ֤Τâ¤Î¤òºî¤ë»ö¤¬½ÐÍè¤Þ¤¹¡£

 

»¨ÃÌ | permalink | comments(0) | trackbacks(0)

¥Ä¥¤¥Ã¥¿¡¼¥¢¥Ê¥ê¥Æ¥£¥¯¥¹

¥Ä¥¤¥Ã¥¿¡¼¤Ë´Ø¤¹¤ëµ­»ö¤Î³¤­

 

Á°²ó¤Ï¥Ä¥¤¥Ã¥¿¡¼¤Î³èÍÑÊýË¡¤Ë¤Ä¤¤¤Æ¡¢µ­»ö¤ò½ñ¤­¤Þ¤·¤¿¤¬¡¢

º£²ó¤Ï¡¢¤½¤Î¸ú²Ì¤ò¤É¤Î¤è¤¦¤Ë¤·¤Æ¸¡¾Ú¤¹¤ë¤«¤Ç¤¹¡£

 

¥Ä¥¤¥Ã¥¿¡¼¤Ë¤Ï¡¢¥Ä¥¤¥Ã¥¿¡¼¥¢¥Ê¥ê¥Æ¥£¥¯¥¹¤Ê¤ë

̵ÎÁ¤ÎʬÀϥġ¼¥ë¤¬¤¢¤ë¤ó¤Ç¤¹¡ª¡ª

 

»È¤¤Êý¤Ï¤³¤Á¤é

http://fukazone.com/note/twitteranalytics.html

¥¢¥Ê¥ê¥Æ¥£¥¯¥¹¤Î¥í¥°¥¤¥ó¤Ï¤³¤Á¤é

https://analytics.twitter.com/

 

¥¢¥Ê¥ê¥Æ¥£¥¯¥¹¤Ë¥í¥°¥¤¥ó¤·¤Æ¡¢

¾å¤Î¥á¥Ë¥å¡¼¤Ç¥Ä¥¤¡¼¥È¤òÁª¤ó¤Ç¡¢

³Æ¥Ä¥¤¡¼¥È¤ò¥¯¥ê¥Ã¥¯¤¹¤ì¤Ð¡¢

¡¦²¿¿Í¤Ëɽ¼¨¤µ¤ì¤¿¤«

¡¦²¿¿Í¤¬È¿±þ¤·¤Æ¤¯¤ì¤¿¤«

¡¦²¿¿Í¤¬¥×¥í¥Õ¥£¡¼¥ë¤ò¸«¤Æ¤¯¤ì¤¿¤«

¡¦²¿¿Í¤¬¥ê¥Ä¥¤¡¼¥È¤·¤Æ¤¯¤ì¤¿¤«

¤Ã¤Æ´¶¤¸¤Î¿ô»ú¤¬Ê¬¤«¤ê¤Þ¤¹¡£

¤Þ¤¿¡¢°ìÍ÷¤ÇÈ¿±þ¿ô¤äÈ¿±þ¤ÎΨ¤âʬ¤«¤ë¤ó¤Ç¡¢

¤É¤Î¥Ä¥¤¡¼¥È¤ÎÈ¿±þ¤¬Îɤ«¤Ã¤¿¤«°ìÌܤÇʬ¤«¤ê¤Þ¤¹¡£

 

¤¼¤ÒÆüº¢¤Î¤Ä¤Ö¤ä¤­¤Î»²¹Í¤Ë¤É¤¦¤¾

 

JUGEM¥Æ¡¼¥Þ¡§¥Ó¥¸¥Í¥¹

 

»¨ÃÌ | permalink | comments(0) | trackbacks(0)

Twitter³èÍѽÑ

³èÍѤµ¤ì¤º¡¢ÊüÃÖ¤µ¤ì¤Æ¤¤¤ë¤³¤Î¥Ö¥í¥°

Êü¤Ã¤Æ¤ª¤¯¤Î¤âÌÞÂΤʤ¤¤Î¤Ç¡¢

²¿¤«¤·¤é½ñ¤¤¤Æ¤¤¤³¤¦¤È»×¤¤¤Þ¤¹¡£

 

º£²ó¤Î¥Æ¡¼¥Þ¤Ï´ë¶È¤ÎTwitter³èÍѤˤĤ¤¤Æ¤Ç¤¹¡£

¤È¤¤¤Ã¤Æ¤â¡¢³èÍÑÊýË¡¤Ê¤É¤¬½ñ¤«¤ì¤¿¥µ¥¤¥È¤Ï

¤¿¤¯¤µ¤ó¤¢¤ë¤Î¤Ç¡¢¤Þ¤º¤Ï¡¢¤½¤Á¤é¤ò¤´Í÷¤¯¤À¤µ¤¤¡£

https://ferret-plus.com/1298
http://web-tan.forum.impressrd.jp/e/2015/06/09/19877

 

¤³¤ì¤é¤Î³èÍÑÊýË¡¤Ë¤Ä¤¤¤Æ¡¢¤¤¤¯¤Ä¤«¤Î¶¦ÄÌÅÀ¤¬¤¢¤ë¤È»×¤¤¤Þ¤¹¡£

£±¤ÄÌܤϡ¢¥³¥ß¥å¥Ë¥±¡¼¥·¥ç¥ó¤òÂçÀڤˤ·¤Æ¤¤¤ë¤È¤¤¤¦»ö¡£

£²¤ÄÌܤϡ¢¾¦ÉʤǤÏ̵¤¯¡¢¤Ä¤Ö¤ä¤¤¤Æ¤¤¤ë¿Í¤Î¸ÄÀ­¤òÇä¤Ã¤Æ¤¤¤ë¤È¤¤¤¦»ö¡£

¤³¤Î£²¤Ä¤¬Twitter¤ò³èÍѤ¹¤ë¾å¤ÇÂç»ö¤Ë¤Ê¤Ã¤Æ¤¯¤ë¤Î¤Ç¤Ï¤Ê¤¤¤Ç¤·¤ç¤¦¤«¡£

 

´ë¶È¤ÇTwitter¤òôÅö¤µ¤ì¤Æ¤¤¤ëÊý¤Ï»²¹Í¤Ë¤·¤Æ¤ß¤Æ²¼¤µ¤¤¡£

 

 

»¨ÃÌ | permalink | comments(0) | trackbacks(0)

½êÍ­ºâ»º¤ÎÇäµÑ¤Ë¤Ä¤¤¤Æ

¤³¤ÎÅÙ¡¢ÀŲ¬»Ô¤Þ¤Á¤Å¤¯¤ê¸ø¼Ò¤Ç¤Ïºâ»º¡ÊÅÚÃϡˤÎÇäʧ¤¤¤ò°ìÈ̶¥ÁèÆþ»¥¤Ë¤è¤Ã¤Æ¼Â»Ü¤·¤Þ¤¹¡£
ʪ·ï¤Ï²¼µ­¤Î¤È¤ª¤ê¡£

£±¡¥ÀŲ¬»Ô°ª¶èÀ¥Ì¾¼·ÃúÌÜ4370ÈÖ18
¡¡¡¡¼Â¬¿ôÎÌ¡¡548.63­Ö

£²¡¥ÀŲ¬»Ô°ª¶èÀ¥Ì¾¼·ÃúÌÜ4446ÈÖ1
¡¡¡¡¼Â¬¿ôÎÌ¡¡603.74­Ö

ξʪ·ï¤È¤â¸½¶·ÃÏÌܵڤÓÅе­ÃÏÌܤÏÂðÃϤȤʤäƤª¤ê¤Þ¤¹¡£
¾Ü¤·¤¤»ñÎÁ¤Ë¤Ä¤­¤Þ¤·¤Æ¤Ï¡¢¥Û¡¼¥à¥Ú¡¼¥¸¤Ë¤Æ¤´³Îǧ¤¯¤À¤µ¤¤¡£


 
Ãó¼Ö¾ì | permalink | comments(0) | trackbacks(0)