Hi -- I'm trying to write a formula that looks at several different arrays of text values, that are located in non-contiguous columns, and say is there are duplicate names listed or not. I'm attaching a screenshot that shows an example.
Array 1 = {Lead1, Lead2}
Array 2 = {Manager1, Manager2}
Array 3 = {Associate1, Associate2}
The formula would have to disregard blank cell values as well. In the example, you can see that Lead1 and Associate1 both have "Lomez" as a value, so the result should say that there are duplicates
Array 1 = {Lead1, Lead2}
Array 2 = {Manager1, Manager2}
Array 3 = {Associate1, Associate2}
The formula would have to disregard blank cell values as well. In the example, you can see that Lead1 and Associate1 both have "Lomez" as a value, so the result should say that there are duplicates