selfish
2/1/2016 - 8:09 AM

Spreadsheets relative indirect.

Spreadsheets relative indirect.

identity
content_copyfile_download
=SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","") & ROW() // Current cell path (i.e. A5)
=INDIRECT(SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","") & ROW()) // Current cell content.