First I set up key columns (Col H) on Actual and Schedules Sheets using this formula (example from Actuals!H2)
=IF(A2=Sheet2!$C$3, IF(Sheet2!$J$3="", IF(Sheet2!$F$3=C2,H1+1,H1), IF(Sheet2!$J$3=D2, H1+1, H1)),H1)
This counts off all the rows that match your criteria from Sheet2
Then on Sheet2 in B8 for example, I use INDEX/MATCH to pull back the values in each row where the values increment in Col H
=IF(MAX(Actuals!$H:$H)>=ROW(A1),INDEX(Actuals!$C$2:$C$13,MATCH(ROW(A1),Actuals!$H$2:$H$13,0)),"")
See attachment
Questions?
Important Edit. Need to change that initial
MAX(Actuals!$H:$H)>ROW(A1) TO MAX(Actuals!$H:$H)>=ROW(A1)
for all columns.
Otherwise, you'll not include your last value.
Bookmarks