Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
54
Views
Topic starter
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.
Posted : 09/12/2022 7:26 am
Hello,
You can use LOOKUP for this. In H5, enter following formula:
=LOOKUP(2,1/ISNUMBER(D3:L3),D3:L3)
Br,
Anders
Posted : 10/12/2022 4:18 pm