{"width":"100%","type":"rich","author_url":"https://blog.hatena.ne.jp/ublftbo/","height":"190","provider_name":"Hatena Blog","version":"1.0","author_name":"ublftbo","title":"Excel \u3067\u9023\u756a\u3092\u632f\u308b\u3002\u306a\u308b\u3060\u3051\u7dba\u9e97\u306a\u6570\u5f0f\u3092\u5fc3\u304c\u3051\u3066","url":"https://interdisciplinary.hateblo.jp/entry/2017/08/04/150854","provider_url":"https://hatena.blog","blog_url":"https://interdisciplinary.hateblo.jp/","categories":[],"description":"\u30e1\u30e2\u3002 \u524d\u63d0\u3068\u3057\u3066\u3001 \u9023\u756a\u3092\u632f\u308b\u5217\u306f\u3001\u30c6\u30fc\u30d6\u30eb\uff08ListObject \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\uff09\u306b\u542b\u307e\u308c\u308b \u9023\u756a\u3092\u632f\u308a\u305f\u3044\u5217\u306e\u898b\u51fa\u3057\u306f\u6587\u5b57\u5217\u3067\u3042\u308b \u3068\u3057\u307e\u3059\u3002Excel \u306e\u30c6\u30fc\u30d6\u30eb\u6a5f\u80fd\u3092\u7a4d\u6975\u7684\u306b\u4f7f\u308f\u306a\u3044\u7406\u7531\u306f\u7121\u3044\u3067\u3059\u3057\u3001\u5217\u898b\u51fa\u3057\u304c\u6587\u5b57\u5217\u4ee5\u5916\u3067\u3042\u308b\u5834\u5408\u3082\u3042\u307e\u308a\u7121\u3044\u3060\u308d\u3046\u3001\u3068\u3044\u3046\u8003\u3048\u3067\u3059\u3002 \u203b\u30c6\u30fc\u30d6\u30eb\u540d\u306f\u3001\u65e5\u672c\u8a9e\u7248 Excel \u306e\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u3042\u308b \u30c6\u30fc\u30d6\u30eb1 \u3068\u3059\u308b \u6570\u5f0f\u2193 =IF(TYPE(OFFSET(\u30c6\u30fc\u30d6\u30eb1[@],-1,0))=1,OFFSET(\u30c6\u30fc\u30d6\u30eb1[@],-1,0)+1,1) \u898b\u3084\u3059\u3044\u3088\u3046\u306b\u9069\u5f53\u306b\u6574\u5f62\u3059\u308b\u3068\uff08\u30bb\u30eb\u306b\u305d\u306e\u307e\u307e\u5165\u308c\u308b\u5834\u5408\u306f Alt + Enter \u3067\u6539\u884c\u3057\u3066\u534a\u89d2\u30b9\u30da\u30fc\u30b9\u3067\u30a4\u30f3\u30c7\u30f3\u2026","image_url":null,"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Finterdisciplinary.hateblo.jp%2Fentry%2F2017%2F08%2F04%2F150854\" title=\"Excel \u3067\u9023\u756a\u3092\u632f\u308b\u3002\u306a\u308b\u3060\u3051\u7dba\u9e97\u306a\u6570\u5f0f\u3092\u5fc3\u304c\u3051\u3066 - Interdisciplinary\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_title":"Interdisciplinary","published":"2017-08-04 15:08:54"}