13
15

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 5 years have passed since last update.

Google スプレッドシートで セル参照にR1C1 形式を利用する

Posted at

Google スプレッドシートのセル参照に、R1C1形式を利用したい。
しかし、そのままセルに =R1C1 と入力するとエラーになってしまいます。
indirect関数を利用し=indirect("R1C1",false) と入力すると。エラーにならず期待通りの動作をします。

=indirect("R1C1", false) 1行1列目を参照(A1)
=indirect("R1C1:R3C3", false) 1行1列目から3行3列目を参照(A1:C3)

もちろん、相対参照も利用可能です。

=indirect("R[-1]C", false) 1行上のセルを参照
=indirect("RC[-2]", false) 2列左のセルを参照
=indirect("R[3]C[3]",false) 3行下3列右のセルを参照

他シートの参照もいけます。

=indirect("sheet!R1C1", false) sheetの1行1列目を参照

13
15
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
13
15

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?