Hi James,
You probably want to add the third parameter to the function..
Type may take the values 1, 0, or -1. If Type = 1 or if this optional
parameter is missing, it is assumed that the first column of the search
array is sorted in ascending order. If Type = -1 it is assumed that the
column
I want to match the value in cell f2, I think it is matching the string
'f2'.
=MATCH(F2;A4:A17)
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Den 2006-06-17 20:52:15 skrev G. Roderick Singleton
<[EMAIL PROTECTED]>:
On Sat, 2006-06-17 at 17:51 +0200, Johnny Andersson wrote:
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)
I think y
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
Hi,
I am trying to get calc to return the filename of an image in a folder to a
cell
The images have names like 1001.jpg, 1002.jpg3555.jpg. The spreadsheet
has a column with a matching Product Code value:
1001, 1002,...3555
There are more Product Code values than images, and I cannot have