Requesting help with syntax of formula with multiple ranges

Chris Hallo

Background: There are years (0 through 5) that have processes (1 through 25) and each process has roles (1 through 10). In the attached image, I'm adding a formula in the Test_A1 that should check within all roles/processes per year to determine if it is unique (used only once) within the entire year.

I do already have an Excel file with the ranges so want to ensure:

1. the syntax as-is would check the first two ranges
2. How would I modify it to add each additional range? An example would be great!

Intern98

Hi your formula in A1 will not check if the role are uniques entries for the year.

Replacing 'OR' with 'AND' will help identify if there are duplicates within ranges.