Hello mate try
Helper row in 15 - =COUNTIF(D17:23,">"&0)
I have added this in row 41 and it seems to be okay
=SMALL(IF($D$15:$BOB$15>0,$D$16:$BOB$16,""),COLUMN S($D$41:41))
Noticed you have merged cells on this work sheet and it is interferring with some formulas - be very careful of Merged cells as nothing good will ever come of them and they will cause you issues at some point.
Also row 22 was hidden
|