Finding Distinct Values in Two Columns
I was wondering if it was possible to find the number of distinct values in two columns. In this case I am looking to find if there is an overlap between start and completion dates for a given crew lead.
Is there a reason that I am getting 1 as my output here?
Is there any other way I can accomplish this?
Help Article Resources
Check out the Formula Handbook template!