UNIQUE with two criteria

- [Instructor] Here we'd like to extract a distinct list … of our customers. … And notice one challenge … is that we've got three different people named La Croix, … Gwen, Maxine, Ray La Croix. … We've got three different Gwens, … two different Calvins, … so in order to get our distinct list of customers, … we've got to compare it across two columns. … Let's do that. … Equals UNIQUE. … Double click. … Our array, we're going to highlight both of those columns. … The By column and Occurs Once fields are optional. … We don't need those for this case, so just hit Enter. … There's our list of distinct customers. … …