copy every 30th cell in the column into consecutive cells in anoth

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please help to find out how to copy every 30th cell in the column into
consecutive cells in another one.
Thanks
 
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 said:
Please help to find out how to copy every 30th cell in the column into
consecutive cells in another one.
Thanks
Click to expand...

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding location (or start cell) of highest consecutive values 3
How to count the maximum number of consecutives? 9
copy cells 1
Consecutive numbering 4
EXCEL 1
How to Create Macro to Increase Cell Value to one and Print Worksheet 4
how to delete blank cells between those with entries 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Back
Top