Column “A” contains a list of 363 non empty cells. I try to get the row number of the first empty cell by
=MATCH("";$Erfassungsdaten.A:A;0)
and get
#N/A
as result. How to achieve 364 as result in this case?
Some help would be great.
thx
Great. thx. Got it 
{=MIN(IF(A:A="";ROW(A:A)))}
=AGGREGATE(5;6;IF(A:A="";ROW(A:A)))
Add 1 to =LOOKUP(2;1/(A:A<>0);A:A)