Help Matching Names in 3 columns

I have a list of first names in column A. I need to find a way to list out which ones are listed in Column B which ones are in Column C and which ones are in both. I have used the conditional formatting before to highlight duplicates but that is going to take a long time to sort and compare with this being 1000 names. Is there a way to figure this out with a formula? I have attached a sample sheet to use.

Not all names are exact in column A as they appear in Column B & C but I can find those after. most of them should be the same.

Thanks!

Two helper columns can provide you with these results. Just make sure the names are EXACTLY the same. I had to copy and paste "bob" from the first column into the 2nd two columns to get them to match. So they must have been entered differently.

The following should work in the cases where your names are formatted the same including uppercase letters.

Please Login or Register  to view this content.

Let me know if that works for you!

Originally Posted by hoyasaxa215

Two helper columns can provide you with these results. Just make sure the names are EXACTLY the same. I had to copy and paste "bob" from the first column into the 2nd two columns to get them to match. So they must have been entered differently.

One formula to help eliminate some of the easier formatting problems is:

Please Login or Register  to view this content.

Copy and paste the values generated from this formula on top of the original first names. It should eliminate spaces before and after the names, and always have the first letter uppercase and the following lowercase.

Using the formula that @nflsales provided you will not need any helper columns, just paste the formula* in D2 and double click to copy it down.
*You will need to change the arrays from $B$2:$B$9 to $B$2:$B$286 and from $C$2:$C$9 to $C$2:$C$338 to match the length of the columns in your actual file.

Let me know if you have any questions.