Hi,
Try this in A24:
=INDEX(PartsData!$G$1:G$105,AGGREGATE(15,6,(ROW(PartsData!$D$1:$D$105))/((PartsData!$Q$1:$Q$105='Print Report'!$D$22)*(PartsData!$D$1:$D$105='Print Report'!$A$4)),ROWS($H$1:H1)))
In C24:
=INDEX(PartsData!$J$1:J$105,AGGREGATE(15,6,(ROW(PartsData!$D$1:$D$105))/((PartsData!$Q$1:$Q$105='Print Report'!$D$22)*(PartsData!$D$1:$D$105='Print Report'!$A$4)),ROWS($H$1:J1)))
In D24:
=INDEX(PartsData!$H$1:H$105,AGGREGATE(15,6,(ROW(PartsData!$D$1:$D$105))/((PartsData!$Q$1:$Q$105='Print Report'!$D$22)*(PartsData!$D$1:$D$105='Print Report'!$A$4)),ROWS($H$1:K1)))
Bookmarks