I need a UDF to make live easier. I have a huge excel file and I need a final function (I suppose a UDF) that lists all
values from a range spanning over multiple columns and rows.
I would not really like a macro, since it does not update when certain values are changed.
It's part of a bigger
functionality, but I need this one, really bad, since it spans over 6000 rows as the search range, and 7000 as the search
values. In short:
I got to list all the unique values. They are in specific cells on worksheet 1 (A1:C5 and A25:C31) and should be listed on
worksheet2 starting in field A2. As 'simple' as that. Nothing more, nothing less, just list all unique values of a certain
range, which I specify. If it can not be done, by selecting the two fields separately, it's no problem at all to list all
values in eg A1:C6000. Do note that some of the cells will be blank, and I don't need blanks. I only need the actual data
I added a sample excel file, that shows a representation of the data. I can not upload the actual file,
since it's way too big (60 MB). So a sample file should give you the idea.
Data 1: some value lists multiple columns
Data 2: some value lists, again multiple columns
Desired result: the result as it should be listed.
Thanks in advance...
Cross-ref on the same