Hello, can anyone help with a formula to find the latest input in a field range excluding Nulls? See example attached and screenshot. Thanks
latest data example.png
Hello, can anyone help with a formula to find the latest input in a field range excluding Nulls? See example attached and screenshot. Thanks
latest data example.png
Enter formula in A2 and copy down
=INDEX(B2:G2,MATCH(TRUE,INDEX(ISNUMBER(B2:G2),0),0))
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Try
=INDEX(B2:G2,,SMALL(IF(ISNUMBER($B2:$G2),COLUMN($B$1:$G$1)-COLUMN($B$1)+1,""),COLUMNS($B$1:B1)))
Enter with Ctrl+Shift+Enter
Beauteous, worked great @Alkey. Thanks!
That worked too @JohnTopley. Thanks!
You're welcome. Please don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks