How about using a helper column and concatenating all the data into one cell:

=a1&char(1)&b1&char(1)&....&char(1)&n1

Drag down.

do the same for the other worksheet.

Now use the =isnumber(match(helpercell,sheetB!helpercolumn,0))

and fill down.



Ikke = Huub wrote:

"Dave Peterson" schreef in bericht
...

=isnumber(match(a1,sheetB!a:a,0))
and drag down.

If it finds a match, you'll get True. No match = False.


Thx for your reply but:
I can't get it working.

I found out in dutch version:
isnumber = isgetal
match = vergelijken

But the arguments don't seem to be right.

What I want to do is skip a row (I'm sorry; in earlier posting I mentioned:
skip a line) if that row is completely in the other spreadsheet.

so I think first argument a1 can't be right, it should be e.g. a1:n1
and sheetB!a:a should be sheetB!a:n

But it doesn't work.
And I don't know what I'm doing wrong

Huub

--

Dave Peterson