Code:
=LOOKUP(2,1/(U:U<>""),U:U)
I'm using the above formula and it works fine on my computer. I sent the schedule to some other people and it's working fine for most; however, for one individual, the cell with this formula isn't calculating:
- Her Options are set to Automatic Formulas: all other cells auto calculate fine
- F9: hitting F9 doesn't calculate
- Saving the file doesn't calculate
- The only way it calculates is by hitting F2 into the cell and exiting out
Anyone know what's causing this to not function properly?
Thanks.