Skip to content

Instantly share code, notes, and snippets.

@iphoting

iphoting/gist:c5095851b9bb432f9af1

Created March 31, 2015 09:23
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save iphoting/c5095851b9bb432f9af1 to your computer and use it in GitHub Desktop.
Save iphoting/c5095851b9bb432f9af1 to your computer and use it in GitHub Desktop.
Download ZIP
Excel: Sequential Serial Numbers Formula
Raw
gistfile1.txt
=IFERROR(IF(NOT(AND(ISBLANK(INDIRECT(ADDRESS(ROW(), COLUMN()+1))), ISBLANK(INDIRECT(ADDRESS(ROW(), COLUMN()+2))))),INDIRECT(ADDRESS(ROW()-1, COLUMN()))+1,""),1)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment