{"id":19662,"date":"2021-01-28T00:29:05","date_gmt":"2021-01-27T15:29:05","guid":{"rendered":"https:\/\/cg-method.com\/?p=19662"},"modified":"2022-12-05T12:41:57","modified_gmt":"2022-12-05T03:41:57","slug":"spreadsheet-formula","status":"publish","type":"post","link":"https:\/\/cg-method.com\/spreadsheet-formula\/","title":{"rendered":"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u2502\u4fbf\u5229\u306a\u6570\u5f0f\u30fb\u95a2\u6570"},"content":{"rendered":"\n
\u30ea\u30e2\u30fc\u30c8\u30ef\u30fc\u30af\u3067\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u8cc7\u6599\u3084\u30c7\u30fc\u30bf\u3092\u4f5c\u308b\u3053\u3068\u304c\u5897\u3048\u3066\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n
\u500b\u4eba\u7684\u306b\u3088\u304f\u4f7f\u3046\u6570\u5f0f\u3092\u307e\u3068\u3081\u307e\u3057\u305f\u306e\u3067\u3001\u3082\u3057\u53c2\u8003\u306b\u306a\u308c\u3070\u5e78\u3044\u3067\u3059\u3002<\/p>\n\n\n\n
\u6570\u5f0f\u306e\u4ed5\u7d44\u307f\u304c\u591a\u5c11\u308f\u304b\u3063\u3066\u3044\u308b\u4eba\u3067\u3042\u308c\u3070\u3001\u30b3\u30d4\u30da\u3067\u3059\u3050\u306b\u4f7f\u3048\u308b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n\n\n\n
\u30bb\u30eb\u3092\u5165\u308c\u66ff\u3048\u3066\u3082\u6570\u5b57\u306e\u4e26\u3073\u3092\u5909\u3048\u305f\u304f\u306a\u3044\u3067\u3059\u3088\u306d\uff1f\u305d\u3093\u306a\u6642\u306b\u4f7f\u3048\u307e\u3059\u3002<\/p>\n\n\n\n
\u4e0b\u8a18\u306e\u6570\u5f0f\u3092A1\u304b\u3089\u4e0b\u3078\u9806\u306b\u5165\u308c\u3066\u3044\u304f\u3068\u6570\u5b57\u304c\u9023\u756a\u3067\u3064\u304d\u307e\u3059\u3002\u3082\u3061\u308d\u3093\u30bb\u30eb\u3092\u5165\u308c\u66ff\u3048\u3066\u3082OK<\/p>\n\n\n\n
=IFERROR(OFFSET(INDIRECT(ADDRESS(ROW(),COLUMN())),-1,0)+1,1)<\/code><\/p>\n\n\n\n