Can I do this? If so how?

[mikep]

my files are bigger but here's my example

I have a .xls file with numbers 1 to 10 in a1 to a10

I have another .xls file with 1 to 20 in a1 to a20

I import both in filemaker pro and create a relationship.

This is where I am now.

I want to be able to see the items on one spreadsheet that aren't on the other. Or, I expect to see 11 to 20.

I apologize for the pretty basic post, but the instructions aren't very clear on this.

[Fitch]

You could do something like:

Go to related records (match found set)

Show Omitted Only