Hi,
need assistance with comparing 5 cells and show if its true or false.
example is:
d2:h2 has all 8am as the time, need a formula to show that it is true and if there is a different schedule that it would show false.
thank you in advance
need assistance with comparing 5 cells and show if its true or false.
example is:
d2:h2 has all 8am as the time, need a formula to show that it is true and if there is a different schedule that it would show false.
Book2 | |||||||
---|---|---|---|---|---|---|---|
D | E | F | G | H | |||
1 | 28-Aug | 29-Aug | 30-Aug | 31-Aug | 1-Sep | ||
2 | 8:00 AM | 8:00 AM | 8:00 AM | 8:00 AM | 8:00 AM | ||
3 | 11:00 AM | 11:00 AM | 10:30 AM | 10:30 AM | 9:30 AM | ||
4 | 9:00 AM | 9:00 AM | 8:00 AM | 8:00 AM | 8:00 AM | ||
Sheet1 |
thank you in advance