Hi,
I need to extract unique values based on two conditions. Tried below formula but no luck.
={IFERROR(INDEX('Raw Data'!$R:$R,MATCH(0,COUNTIF(Y10:$Y$10,'Raw Data'!$R:$R)+IF('Raw Data'!$N:$N<>$B$2,1,0)+IF('Raw Data'!$AD:$AD<>$D$2,1,0),0)),"")}
where condition 1 is in $B$2, Condition 2 is in...