I am trying to write a formula that will tell me if the ID numbers that are in 4 columns match each other when a value is present. So if only 2 of the columns have a value I want to know if those 2 match even though 2 of the columns have null values. Here is a preview of what the data looks like. Essentially I need something that says if the cell has a value compare that value to the value (if present) in the 3 other columns.
Any ideas?
Solved! Go to Solution.
Thanks so much!! Worked great.
Thanks so much!! Worked great. Appreciate it