December 8, 2022
In H5 I am trying to figure out how I can get the last numerical value in row 3 (and always get the last numerical value in that row, as data will eventually be added in G3:K3). This is for tracking bloodwork. F3 is the current last entry in the row, but it is a character instead of a number. I'd like to leave that character there (or replace it with something that would indicate there is no numerical value there, without leaving it completely blank). The "-" was put there to indicate the bloodwork was not run on that date. The current formula I was able to find just returns the last entry, not the last numerical entry.