I am trying to make one dynamic unique list from multiple ranges (sorted alphabetically).
The code I currently use works fine for one range
The originating range is located at $B$5:$B$170 and the dynamic result starts at W5. The need is to include the values from another range and create one dynamic list at W5. The other range is located at $G$5:$G$170. Between the list at $B$5:$B$170 and $G$5:$G$170 I would like to have one dynamic unique list created.
Does anyone know a solution for this?
Cheers,
GG
The code I currently use works fine for one range
Excel Formula:
=IFERROR(INDEX($B$5:$B$170, MATCH(0,COUNTIF(W$4:$W4, $B$5:$B$170), 0)),"")
The originating range is located at $B$5:$B$170 and the dynamic result starts at W5. The need is to include the values from another range and create one dynamic list at W5. The other range is located at $G$5:$G$170. Between the list at $B$5:$B$170 and $G$5:$G$170 I would like to have one dynamic unique list created.
Does anyone know a solution for this?
Cheers,
GG