Dynamically extracting a list of unique values from non adjacdent column ranges

[Alberto1976]

Hi,

I have found this formula online

=IFERROR(INDEX($M$25:$M$27, MATCH(0,COUNTIF($A$31:A31, $M$25:$M$27), 0)),"")

which is working great for my scope.

However, I do not know how to make it work for NON ADJACENT column ranges.

I tried this formula:

=IFERROR(INDEX($M$25:$M$27 $O25:$O$27 $Q$25:$Q$27 $S$25:$S$27 $U$25:$U$27 $W$25:$W$27, MATCH(0,COUNTIF($A$31:A31,$M$25:$M$27 $O25:$O$27 $Q$25:$Q$27 $S$25:$S$27 $U$25:$U$27 $W$25:$W$27), 0)),"")

but the cell returns blank.

Any help would be greatly appreciated.

P.S. I am new here, how can I attach my sample Excel file?

Thank you and best regards,
Alberto

Also asked here Dynamically extracting a list of unique values from non adjacdent column ranges

 

[Alberto1976]

Hello,

for those who might need a solution to my same problem, here is the formula that was found correct:

=AGGREGATE(15,6,$M$25:$W$27/ISTEXT($M$25:$W$27)/(--$M$25:$W$27>MAX(A$31:A31)),1)

Please refer to this forum and thread for the whole story:

Dynamically extracting a list of unique values from non adjacdent column ranges [SOLVED]

Hi, I have found this formula online =IFERROR(INDEX($M$25:$M$27, MATCH(0,COUNTIF($A$31:A31, $M$25:$M$27), 0)),"") which is working great for my scope. However, I do not know how to make it work for NON ADJACENT column ranges.

www.excelforum.com

Thank you and kind regards,
Alberto

 

[Alberto1976]

UPDATE:

Updated formula to avoid an error if the cell contains a blank value:

=IFerror(AGGREGATE(15,6,$M$25:$W$27/ISTEXT($M$25:$W$27)/(--$M$25:$W$27>MAX(A$31:A31)),1),"")

Best regards,
Alberto