Forum Discussion
Data Sorting Issue!
Hey Folks! I'm in a bit of a quandry at the moment - I've got two arrays of data containing names. One is larger than the other, and I want to find the common names between them, and then isolate the...
Peter-
First off I want to say that I appreciate your sense of humor. Nice touch! 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....