Repeating a set of data

The Microsoft Excel Blog has a discussion on ways of repeating a set of data, for instance making three copies of every row of a range of data.  I have written a simple UDF to do this job, and also extract specified rows or columns, or rows or columns at a specified spacing. 

Download IndexA.zip

Note that this is an array function, and must be entered with the usual array function procedure:

  • Enter the function in the top left cell.
  • Select the range to be covered by the function.
  • Press F2
  • Press Ctrl-Shift-Enter

For example:

 

indexa1

 

indexa2

 

 

indexa3

 

indexa4

 

About these ads
This entry was posted in Arrays, Excel, UDFs, VBA. Bookmark the permalink.

One Response to Repeating a set of data

  1. Pingback: Daily Download 33: Miscellaneous | Newton Excel Bach, not (just) an Excel Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s