Really not sure where to start with this one. I have multiple criteria that need to be met, and if met, I want a formula that's going to return the corresponding data in B:B of the first instance of that being correct. I'd then like the formula to be able to be dragged down to produce the second, third, fourth etc occurrence. The criteria are below in a previously used countifs formula.
COUNTIFS($A:$A,$BI$11,$C:$C,$BJ$11,$D:$D,$BK$11,G:$G,$BL11)
Hoping someone can assist. Big thanks!
COUNTIFS($A:$A,$BI$11,$C:$C,$BJ$11,$D:$D,$BK$11,G:$G,$BL11)
Hoping someone can assist. Big thanks!