Hello,
Pretty simple I'm sure.
I have two columns, one that contains FIRSTNAME the other contains LASTNAME. There are almost 2,000 people on the list.
I was given another list of only 400 people. Some may be on the original list some are not.
I want to add a column on the list of 400 people that will read TRUE or FALSE based on if their first and last name match the original list.
I am aware that some people may have the same name and not worried about that right now.
I would prefer a formula to VBA.
You guys are the best!
Pretty simple I'm sure.
I have two columns, one that contains FIRSTNAME the other contains LASTNAME. There are almost 2,000 people on the list.
I was given another list of only 400 people. Some may be on the original list some are not.
I want to add a column on the list of 400 people that will read TRUE or FALSE based on if their first and last name match the original list.
I am aware that some people may have the same name and not worried about that right now.
I would prefer a formula to VBA.
You guys are the best!