Does someone knows how to find the first value after a number of empty cells?
W Willem May 12, 2005 #1 Does someone knows how to find the first value after a number of empty cells?
D Domenic May 12, 2005 #2 Try... =INDEX(A1:A100,MATCH(TRUE,A1:A100<>"",0)) ....confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Hope this helps!
Try... =INDEX(A1:A100,MATCH(TRUE,A1:A100<>"",0)) ....confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Hope this helps!
J Jason Morin May 12, 2005 #3 Just an alternative: =INDEX(A1:A100,MATCH("*?*",A1:A100&"",0)) Array-entered (ctrl+shift+enter). HTH Jason Atlanta, GA
Just an alternative: =INDEX(A1:A100,MATCH("*?*",A1:A100&"",0)) Array-entered (ctrl+shift+enter). HTH Jason Atlanta, GA
