Alberto1976
New Member
- Joined
- Apr 2, 2020
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
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
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
Last edited by a moderator: