Copy every nth cell across columns

  • Thread starter Thread starter TMilner
  • Start date Start date
T

TMilner

I have been trying to copy certain data that is arranged
consistently across columns where the data that I want to
put into a summary sheet would be from the same row but
every 7th column going to the right from cell A4. Is
there an easy way to do this? I have tried the every nth
row but it won't let me copy the first occurence of data
in my source sheet.

Thanks in advance for any advice,
TMilner
 
Use something like

=OFFSET(Sheet1!$A$4,,COLUMN(A4)*7-7)

copy across will give you A4, H4 and so on

if you want A4, G4 replace 7 by 6
 

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

nth row or column counting 1
offset every nth column 2
Excel Formula to copy every nth row 1
Skipping cells for SUMIF or COUNTIF functions?? 9
every nth cell by columns not rows.... 1
sum last nth cells 4
Formula for Next Sheet and Every Other Cell 12
selecting every eg 5th cell in a worksheet 2

Back
Top