What can I add to this formula in Excel to tell it when it fills up range B4:B14 on COMPOSIT PG 1 to continue down the same range in
COMPOSITE PG2?
COMPOSITE PG2?
Code:
=IFERROR(IF(C2="Table Row",MATCH(SpecNo,Table2[LYB Spec],0),IF(MATCH(SpecNo,Table2[LYB Spec],0)+COUNTIF(Table2[LYB Spec],SpecNo)
<=C2+1,"",IF(ROW(C3)/2=INT(ROW(C3)/2),MAX(IF((Table2[LYB Spec]=SpecNo)*(Table2[Overall Pipe Description]=INDEX
(Table2[Overall Pipe Description],C2)),ROW(Table2[Overall Pipe Description])-1,"")),
MIN(IF((Table2[LYB Spec]=SpecNo)*(Table2[Overall Pipe Description]=INDEX(Table2[Overall Pipe Description],C2+1)),
ROW(Table2[Overall Pipe Description])-1,""))))),"")