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, 04:37 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

Jeffery - OK that works - but why???

I did find that the column is really not blank cells - it has spaces.
The formula for column N is =IF(B14=" "," ",D14+E14+H14) which is inserting a space.

What is the 9.99999999999999E+307 doing? Why 307?

Thanks for your help!
Mike

Reply With Quote