Hello,
Need help to compare values across the week for each employee and determine if the numbers are a match across the week not including "0" (Days Off).
I've used the formula below but can't seem to get the end result below
| Employee ID | Mon | Tue | Wed | Thu | Fri | Sat | Sat | Results |
| 1 | 8 | 8 | 8 | 8 | 8 | | | Match |
| 2 | | 8 | 8 | 8 | 8 | 8 | | Match |
| 3 | 8 | 8 | 4 | 4 | 8 | 8 | | No Match |
| 4 | 4 | 4 | 4 | 4 | 4 | | | Match |
| 5 | 10 | 10 | 10 | 5 | 5 | | | No Match |
IF ([MONDAY] != "0" OR [TUESDAY] != "0" OR [WEDNESDAY] != "0" OR [THURSDAY] != "0" OR [FRIDAY] != "0" OR [SATURDAY] != "0" OR [SUNDAY] != "0") THEN
IF ([Monday] = [Tuesday] OR [Monday] = [Wednesday] OR [Monday] = [Thursday] OR [Monday] = [Friday] OR [Monday] = [Saturday] OR [Monday] = [Sunday] OR [Tuesday] = [Wednesday] OR [Tuesday] = [Thursday] OR [Tuesday] = [Friday] OR [Tuesday] = [Saturday] OR [Tuesday] = [Sunday] OR
[Wednesday] = [Thursday] OR [Wednesday] = [Friday] OR [Wednesday] = [Saturday] OR [Wednesday] = [Sunday] OR
[Thursday] = [Friday] OR [Thursday] = [Saturday] OR [Thursday] = [Sunday] OR
[Friday] = [Saturday] OR [Friday] = [Sunday] OR
[Saturday] = [Sunday]) THEN
"Match found"
ELSE
"No match"
ENDIF
ELSE
"Empty values found"
ENDIF
