G Guest Nov 1, 2007 #1 I'm looking for a function that will return the value of the first non-blank cell in a range.
D domenic22 Nov 1, 2007 #2 Try... =INDEX(A2:A100,MATCH(TRUE,A2:A100<>"",0)) ....confirmed with CONTROL+SHIFT+ENTER. Hope this helps!
Try... =INDEX(A2:A100,MATCH(TRUE,A2:A100<>"",0)) ....confirmed with CONTROL+SHIFT+ENTER. Hope this helps!
D Don Guillett Nov 1, 2007 #3 Try this entered normally if TEXT =INDEX(A2:A100,MATCH("*",A2:A100,0),0)
H Harlan Grove Nov 1, 2007 #4 Don Guillett said: Try this entered normally if TEXT =INDEX(A2:A100,MATCH("*",A2:A100,0),0) Click to expand... .... But if not text or not necessarily text, the following array formula would find it. =INDEX(A2:A100,MATCH(FALSE,ISBLANK(A2:A100),0))
Don Guillett said: Try this entered normally if TEXT =INDEX(A2:A100,MATCH("*",A2:A100,0),0) Click to expand... .... But if not text or not necessarily text, the following array formula would find it. =INDEX(A2:A100,MATCH(FALSE,ISBLANK(A2:A100),0))
