Hey, all nice people out there! =)
I want to search for the first row in a column that contains nothing, so I
tried this:
=PASSA("";B1:B32000)
PASSA is MATCH in English version of OpenOffice.org Calc. I can't believe
that they translated this to Swedish! Why did they do that? I know it's
not OpenOffice.org:s fault, it's the same with Excel, so I guess
OpenOffice.org just tried to be compatible with Excel, but still...
So, now you know that PASSA=MATCH, at least, so if you are going to try
this, type MATCH wherever I typed PASSA.
Now, this doesn't seem to find anything, so it returns "#Saknas" (which is
Swedish for "#Missing" or "#Not found" or whatever the message says in
English version of OpenOffice.org Calc).
I changed the formula to the following:
=PASSA(3;B1:B32000)
Then I entered 3 in B4.
Still the same message: #Saknas.
Now I change to
=PASSA(3;B1:B32000;0)
Result: 4
This is correct, but the help says that omitting the last parameter is the
same as entering 0, but that's obviously not correct.
So back again to the original formula, changing it to:
=PASSA("";B1:B32000;0)
Still the original result: #Saknas.
I try another text string, a known one:
=PASSA("Johnny Andersson";B1:B32000;0)
Result: 2
This is also correct.
So the problem is that I don't know how to search for the first empty cell
in a column and have its row as the result.
After experimenting for a while I came up with this "workaround":
=PASSA("Ööö";B1:B32000;1)+1
This SEEMS to work as long as I use only alphabetic letter a-ö (Swedish
alphabet). For users of the English version, I guess the followin gwould
work the same way:
=MATCH("Zzz";B1:B32000;1)+1
But hey, is there no other way to do this? It hurts my sense of what's
right and wrong... It seems like MATCH ignores empty cells. Is there
another command that does not ignore empty cells? Something like
LookupFirstEmptyCell or something like that? Would be handy for me but
maybe for no one else...
Thanks!
--
Johnny
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
