Forum Discussion
Comparative Algorithms?
Hey y'all. I've got two very large, different sized arrays that I need to find common elements between. For example, consider that I have the two following, arbitrary, made-up arrays: I hav...
I don't think you need code to accomplish your task. You can use this solution:
Let me know if you would prefer code. It's probably not so bad to do it that way either.
Peter-
Not sure you can do what you want all in one formula but I've used a two and a few helper columns in order to accomplish the task. You'll need to adjust the formulas based on your data structure.
1. An Array Formula to get unique values in each list
2. A simple Vlookup
I'm going to attach an example file as I think it may be easier to comprehend. When entering the array formula use key combination CTRL + SHIFT + ENTER then drag down.... When using the vlookup you can simple put this formula in cell B13 and then drag to the right and then down....