Excel Magic Trick 977: Lookup First Non Empty Cell In A Range, Lookup Last Number In A Range
Download Excel Start File: https://people.highline.edu/mgirvin/Y...
Download Excel File: http://people.highline.edu/mgirvin/Ex...
Two Formulas for Lookup First Non Empty Cell:
1. {=INDEX(E2:L2,MATCH(TRUE,E2:L2 not "",0))}
2. {=INDEX(E2:L2,MATCH(FALSE,ISBLANK(E2:L2),0))}
Formula to lookup last number:
3. =LOOKUP(9.99E+307,E2:L2)
Busn 214 Joyce April Method
