Filter Multiple Range over Multiple Columns?

[dakke]

I have values in Worksheet 1, spread over A1:D25 and A200: D250.
In worksheet2 I have values again from A1:D25 and A200:D250.

Is is possible to only get the unique values of those 4 ranges with the advanced filter? They all need to be shown in eg worksheet 3 starting in A1, (so kinda merged in a sense)?

Is that a thing more for a UDF, or is there a excel function/option that does exactly that?

I have been looking for ages for that kind of function/option, since I thought it must be possible. But this sure does not look to be a standard functionality, or is it?

[dakke]

I found this thing, which almost does what I wanted. Is this difficult to modify so it becomes a UDF or is it totally different?

It still does not list it in a single column, but at least sorts a range spanning over multiple columns.

Please Login or Register  to view this content.