【SpreadSheet】配列名を順番に羅列する関数(A,B,C,…,AA,…,AAA,…)

f:id:cland741953:20171219160019p:plain

縦に羅列する場合
=REGEXREPLACE(ADDRESS(1,ROW()),"^\$(.*)\$.*","$1")

横に羅列する場合
=REGEXREPLACE(ADDRESS(1,COLUMN()),"^\$(.*)\$.*","$1")