Forum

Notifications
Clear all

How to get last numerical value in a row that contains numbers and characters

2 Posts
2 Users
0 Reactions
54 Views
(@doctorblue)
Posts: 1
New Member
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
Anders Sehlstedt
(@sehlsan)
Posts: 968
Prominent Member
 

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
Share: