I have three large sets of data (each column has up to 50,000 rows). The data are names (text) not numbers. I would like to create a fourth data set comprised of the names that are present in ALL three original columns. Basically, if a name is on list one, two, AND three, then it is placed on the fourth list. If the name is on just one or two of the three, then it will not be placed on the fourth list. Can I complete this sorting in Excel automatically? The datasets are too large to manipulate manually. Thanks.