I am struggling with the following formula in that attached workbook
Under Summary tab, I have posted highlighted yellow the result I want from the drawing list and put the formula in a couple of lines below…
=INDEX('Drawing list'!$B:$B,AGGREGATE(15,6,ROW('Drawing list'!$B$6:$B$
50))/(('Drawing list'!$G$6:$G$50=$B8)*('Drawing list'!$C$6:$C$50=$E8)*('Drawing list'!$D$6:$D$50=$F8)*('Drawing list'!$E$6:$E$50=$G8)),ROWS(D$8:D8))
I have learnt such a formula here, but sometimes have to play around with it to get it to work, but this time no matter what I do I cant get it to work
I am presuming the error is in this section:
INDEX('Drawing list'!$B:$B,AGGREGATE(15,6,ROW('Drawing list'!$B$6:$B$750))/
I am never quite sure what the B:B and ('Drawing list'!$B$6:$B$750) are doing? Sso I never know till I get the result if I am using this section correctly - its a trial and error story! Can anyone explain what these sections are doing?
Bookmarks