=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...