|
|
#1
01-23-2018, 02:47 PM
|
|||
|
|||
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 
|
|
|
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 |
Windows 10 
Office 2010 64bit
Threaded Mode