Thread
: [Solved]
Formula for reference last non empty cell in row
View Single Post
02-20-2017, 01:23 AM
xor
Windows 10
Office 2016
Expert
Join Date: Oct 2015
Posts: 1,103
Attached a file.
Edit:
Please change the formula in U9 to:
=LOOKUP(2,1/(ISTEXT($V10:$XFD10)),$V10:$XFD10)
and copy down.
Attached Files
LOG_2.xlsx
(149.0 KB, 12 views)
xor
View Public Profile
Find all posts by xor