Copying Excel Formulas

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

Guest

I have a spreadsheet of data that is set up kind of like a form in that, for
most of the data, I have 3 blank columns separating between each record. I
am trying to simply pull the data into another sheet using a formula that
references the cell in the original sheet.

Is there a way for me to copy the formulas across to where it only picks up
every fourth column?
 
Try this for copying Row1 from Sheet1 across columns, copying every 4th
column:

=INDEX(Sheet1!1:1,4*COLUMNS($A:A)-3)
 
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

Set formulae to read the adjacent or next spreadsheet 1
Complex Median Formula 0
Dependent drop down dynamic range formula, off sheet. 7
SUMIF, 3D FORMULA, EXCEL FORMULA HELP 1
Excel Help to copy information from one row at a time to another sheet 1
formula finds values in apparently blank cells 1
Splitting data from one spreadsheet into multiple spreadsheets 2
formula assistance needed 5

Back
Top