INDIRECT(MOD(ROW)) skipping a lot of rows

**PowerSchoolDude** · 07-16-2009, 05:43 PM

Hi! I'm currently working on a report and what I'm trying to do is get a Row of information to pull into 4 rows

My current formula looks like this:
=INDIRECT("'Paste SAP'!H"&IF(MOD(ROW()-1,4)=1,ROUNDDOWN(((ROW())+3/4),0)," "),1)

I change the bolded number to correspond to which row (1,2,3,0) but it's not functioning.

I've done it with other but for some reason this one doesn't work. I've attached the template so you can see what it looks like.

The problem is with the SAP Tab and the info from the Paste SAP tab.

Thanks!

**martindwilson** · 07-16-2009, 06:47 PM

only one i see not working is in b30 coz sap h30 is blank

**PowerSchoolDude** · 07-16-2009, 07:38 PM

I figured it out. It was a misplaced ")".

=INDIRECT("'Paste SAP'!H"&IF(MOD(ROW()-1,4)=1,ROUNDDOWN(((ROW())+3/4),0)," "),1)

Working:
=INDIRECT("'Paste SAP'!H"&IF(MOD(ROW()-1,4)=1,ROUNDDOWN(((ROW()+2)/4),0)," "),1)

Thanks though for taking time to look over it martindwilson.