Skip to content

Instantly share code, notes, and snippets.

@yujihamaguchi

yujihamaguchi/gist:1c6f57eafb33e45393e2

Created August 8, 2014 06:53
Show Gist options
  • Save yujihamaguchi/1c6f57eafb33e45393e2 to your computer and use it in GitHub Desktop.
Save yujihamaguchi/1c6f57eafb33e45393e2 to your computer and use it in GitHub Desktop.
Download ZIP
[Excel] Excellで可変リストを入力規則に設定したい場合
Raw
gistfile1.txt
=OFFSET(INDIRECT("Sheet2!A2"),0,0,COUNTA(INDIRECT("Sheet2!$A$2:$A$30")),1)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment