Skip to content

Instantly share code, notes, and snippets.

@xCASx

xCASx/Excel duplicate in order rows

Last active August 29, 2015 14:02
Show Gist options
  • Save xCASx/a34bf49897f071e40ee5 to your computer and use it in GitHub Desktop.
Save xCASx/a34bf49897f071e40ee5 to your computer and use it in GitHub Desktop.
Download ZIP
Excel duplicate in order rows
Raw
Excel duplicate in order rows
// Next formula makes 12 copies in C for each row in A in a determined order
=ИНДЕКС(A:A;ОКРВВЕРХ(ЧСТРОК(C$1:C1)/12;1))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment