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:28 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

Try this...

=INDEX(N:N,MATCH(9.99999999999999E+307,N:N))

Reply With Quote