Lookup to find first non-blank cell

		Microsoft Office Forums > Microsoft Excel > Excel
Lookup to find first non-blank cell

FAQ

Mark Forums Read

Thread Tools

Display Modes

01-23-2018, 02:47 PM

mactoolsix mactoolsix is offline

Windows 10 Lookup to find first non-blank cell

Office 2010 64bit

Novice

Join Date: Jan 2018

Posts: 4

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)

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Lookup and replace cell values	rgauss	Excel	3	10-03-2016 04:01 PM
LOOKUP - Complex lookup with 2 lookups in 1 cell	sglandon	Excel	6	05-05-2016 09:44 AM
Formulato say if cell is blank do this, if not blank do this.	mbesspiata	Excel	1	01-17-2015 05:02 AM
Place 0 in blank cell	mbesspiata	Excel	5	06-20-2014 07:00 PM
won't show blank cell	bhum	Excel	2	01-28-2014 02:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:58 AM.