Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 28th 05, 08:37 PM
shortcuts
 
Posts: n/a
Default copy every 30th cell in the column into consecutive cells in anoth

Please help to find out how to copy every 30th cell in the column into
consecutive cells in another one.
Thanks

  #2   Report Post  
Old March 28th 05, 08:40 PM
N Harkawat
 
Posts: n/a
Default

With A1 as the starting cell as I understand you want 30 cells below so cell
A31 and then a61 and so on use
=OFFSET($A$1,ROW()*30,0) on cell B1 and copy it down column B

"shortcuts" wrote in message
...
Please help to find out how to copy every 30th cell in the column into
consecutive cells in another one.
Thanks



  #3   Report Post  
Old March 29th 05, 07:28 AM
Aladin Akyurek
 
Posts: n/a
Default

shortcuts wrote:
Please help to find out how to copy every 30th cell in the column into
consecutive cells in another one.
Thanks


Let A2:A1000 house the source data and C2 the first destination cell.

In B2 enter & copy down:

=INDEX($A$2:$A$1000,(ROW()-ROW(C$2))*3+1)


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I copy a function for comparison but keep first cell value. N'wester Excel Worksheet Functions 0 February 22nd 05 03:53 AM
Can I copy a combo box in Excel 2002 with a relative cell link? Bozo Excel Discussion (Misc queries) 1 February 17th 05 02:05 AM
Unable to Copy COUNTA() with cell references EugenioB Excel Worksheet Functions 1 February 16th 05 01:07 PM
Copy text from same cell on every sheet to title sheet? Jon Excel Discussion (Misc queries) 2 February 9th 05 03:11 PM
Copy formula to every 12th cell Jerry Derfler Excel Worksheet Functions 3 November 14th 04 11:09 PM


All times are GMT +1. The time now is 02:20 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017