Thread: [Solved] Formula for reference last non empty cell in row
View Single Post
 
Old 02-20-2017, 01:23 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,103
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Attached a file.


Edit:

Please change the formula in U9 to:

=LOOKUP(2,1/(ISTEXT($V10:$XFD10)),$V10:$XFD10)

and copy down.
Attached Files
File Type: xlsx LOG_2.xlsx (149.0 KB, 12 views)
Reply With Quote