Trying to use a formula to add the word UPDATED in cell (I). If any changes in value from column B to H then to add the word UPDATED. Though if no changes occur by certain day then leave blank. So lets say its Wednesday right. Then number (4) example shouldn't have the word updated in cell (I)and leave that blank cell blank. Since its Wednesday and has 0 Value.
Or if there is a better way to do it. I am open to it thanks
Excel 2016 (Windows) 32 bit
Or if there is a better way to do it. I am open to it thanks
Excel 2016 (Windows) 32 bit
A | B | C | D | E | F | G | H | I | J | |
---|---|---|---|---|---|---|---|---|---|---|
1 | 9TH (1) | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | | Start |
2 | Reg Hrs | 0 | 0 | 0 | 0 | 0 | | | | |
3 | OT Hrs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | |
4 | DT Hrs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Avg People | |
5 | Total Employees | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | | |
6 | ||||||||||
7 | 9TH (2) | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | | |
8 | Reg Hrs | 25 | 0 | 0 | 0 | 0 | | | UPDATED | <--Want to add the word update when a change happens |
9 | OT Hrs | 30 | 0 | 0 | 0 | 0 | 0 | 0 | | |
10 | DT Hrs | 35 | 0 | 0 | 0 | 0 | 0 | 0 | Avg People | |
11 | Total Employees | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | | |
12 | ||||||||||
13 | 9TH (3) | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | | No changes within a 24 hour day |
14 | Reg Hrs | 25 | 0 | 0 | 0 | 0 | | | | |
15 | OT Hrs | 30 | 0 | 0 | 0 | 0 | 0 | 0 | | |
16 | DT Hrs | 35 | 0 | 0 | 0 | 0 | 0 | 0 | Avg People | |
17 | Total Employees | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | | |
18 | ||||||||||
19 | 9TH (4) | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | | A change happened again on Tuesday |
20 | Reg Hrs | 25 | 50 | 0 | 0 | 0 | | | UPDATED | |
21 | OT Hrs | 30 | 10 | 0 | 0 | 0 | 0 | 0 | | |
22 | DT Hrs | 35 | 5 | 0 | 0 | 0 | 0 | 0 | Avg People | |
23 | Total Employees | 0 | 0 | 0 | 0 | 0 | 0 | 0.0 | | |
24 |
Sheet: Sheet1 |