As an Example, Let's say I have three columns of data. (Column A, B, and C) Column A has numbers 1 - 10 populated. In Column B, numbers 5-15. Column C would compare values in both Columns A and B; however it should not count a matching condition twice. In this example 5 would be seen in both Column A and B. When Compairing both A & B - how do I either exclude a match condition or only count a match condition as 1 data point instead of 2?
Bookmarks