fill rows with alternating data ?

  • Thread starter Thread starter MPSingley
  • Start date Start date
M

MPSingley

1 =IF(AB413="No Data","",'Data Entry (yearly)'!AQ6)

Code 1 =IF(AB413="No Data","",'Data Entry (yearly)'!AR6)

Position 1 =IF(AB413="No Data","",'Data Entry (yearly)'!AS6)

2 =IF(AB414="No Data","",'Data Entry (yearly)'!AQ7)

code 2 =IF(AB414="No Data","",'Data Entry (yearly)'!AR7)

postion 2 =IF(AB414="No Data","",'Data Entry (yearly)'!AS7)

How would I drag these sets of three rows down as shown from 1 to 2 ???



I am very stuck!! If anyone could help me out with this problem it
would be great appreciated!!!
Thank You in advance!!

thanks,
Matt
 
Might be worth trying
=IF(OFFSET(AB$413,INT(ROW()-1/3),0)="No Data","",'Data Entry
(yearly)'!OFFSET($AQ$6,INT(ROW()-1/3),MOD(ROW()-1,3))
(assuming that your first formula is in row 1; if not, change the number
that you subtract from ROW() in the various places in the formula).
 

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

Excel Message box called if 1 of 3 options is entered. 4
how to print only rows with data without inlcuding rows with a formula 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
column headings with data starting in row 1 2
I need to Auto Fill columns with data 2
Adding first three and last three entries in rows of data 6
Data Fill 4
Excel Count of Consecutive Data 0

Back
Top