copying cells at a specific interval

's Computer Specifications

Hello,
I have a row of 12 000 cells, but i want to use just every 4th cell, for
example:
A1
A2
A3
A4
A5
A6
A7
A8
A9
A10
A11
A12
A13

form that row i need just need A1, A4, A8, A12
How can i copy every 4th cell into another row? Or whatever solution to the
problem you offer
could you help me with this?
Thanks

's Computer Specifications

could someone help me with this, please?

's Computer Specifications

in B1
=indirect("A"&row($A1)*4)

drag fill down the column

In your example, A1 is omitted - it is not every 4th cell.

--
Regards,
Tom Ogilvy

"ANton Petrov" <(E-Mail Removed)> wrote in message
news:04C70E22-B05C-4F1D-8223-(E-Mail Removed)...
> could someone help me with this, please?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copying filtered cells from a specific location	kativa	Microsoft Excel Programming	2	4th Apr 2008 01:31 PM
Copying a cell value to a specific cells	MJKelly	Microsoft Excel Programming	1	16th Mar 2008 12:07 AM
Copying specific cells from a sheet to another	Catalin	Microsoft Excel Misc	1	28th Jul 2006 11:59 PM
Copying cells to a specific position	=?Utf-8?B?TW9ydGVu?=	Microsoft Excel Worksheet Functions	0	19th Oct 2004 08:19 PM
Copying specific cells ?	brazen234	Microsoft Excel Misc	4	17th Jul 2004 10:19 PM