Microsoft Office Forums - View Single Post - Lookup to find first non-blank cell

Thread: Lookup to find first non-blank cell

View Single Post

Old

01-23-2018, 02:47 PM

mactoolsix mactoolsix is offline

mactoolsix is offline

mactoolsix uses Windows 10

Windows 10 mactoolsix uses Office 2010 64bit

mactoolsix uses Office 2010 64bit

Office 2010 64bit

Novice

The original poster

Join Date: Jan 2018

Posts: 4

mactoolsix is on a distinguished road

Default

Lookup to find first non-blank cell

I have spreadsheet with a column (N14:N68) of numbers and blanks.
I want to use the last value in the column.

=LOOKUP(2,1/(N14:N68<>""),N14:N68)

This returns a blank answer.

I have attached a spreadsheet example with this post.

Thanks!!
Mike

Attached Files

RMS Sample.xlsx (15.1 KB, 11 views)

Reply With Quote