May 06 2019 12:40 PM
I have a two dimensional array $s$5:$v$14 that contains numbers and blanks derived from formulas within
In $w$5:$w$14 are numbers
I want in col $X to list the numbers from $w$5:$w$14 that are not in the array $S$5:$v$14
May 06 2019 01:59 PM
Solution@Dichotomy66 , if like this
when in X5
=IFERROR(INDEX($W$5:$W$14,AGGREGATE(15,6,1/(COUNTIF($S$5:$V$14,$W$5:$W$14)=0)*(ROW($W$5:$W$14)-ROW($W$4)),(ROW()-ROW($X$4)) )),"")
and drag it down
May 06 2019 02:04 PM
May 06 2019 02:27 PM
@Dichotomy66 , you are welcome
May 06 2019 01:59 PM
Solution@Dichotomy66 , if like this
when in X5
=IFERROR(INDEX($W$5:$W$14,AGGREGATE(15,6,1/(COUNTIF($S$5:$V$14,$W$5:$W$14)=0)*(ROW($W$5:$W$14)-ROW($W$4)),(ROW()-ROW($X$4)) )),"")
and drag it down