Hi,
Small problem: =LARGE(IF(OR($C:$C=$D3;$J:$J;$D3);$A:$A;"");C16)
Can't get the formula above to work, can anyone see my mistake? Trying to return largest value from A:A, if cell D3 matches C:C or J:J.
A:A is column 1,2,3,4,5,6
C:C is A,B,D,B,D,A
J:J is B,D,A,D,A,B
So if I have B in cell D3 I would like formula return 6,4,2,1 (these are ofcourse in different cells)
Small problem: =LARGE(IF(OR($C:$C=$D3;$J:$J;$D3);$A:$A;"");C16)
Can't get the formula above to work, can anyone see my mistake? Trying to return largest value from A:A, if cell D3 matches C:C or J:J.
A:A is column 1,2,3,4,5,6
C:C is A,B,D,B,D,A
J:J is B,D,A,D,A,B
So if I have B in cell D3 I would like formula return 6,4,2,1 (these are ofcourse in different cells)