Relationship?

[klingsc1]

I have two fields:

Field A contains date numbers:

733585

733586

733587

733588

733589

733590

733591

Field B contains date numbers:

733586

733587

733588

733589

733590

I need to be able to identify the number of dates in Field B that are also in Field A. The answer I would be looking for is 5 in this example.

Any ideas on how to accompish this?? Relationship??

[comment]

The context of your question is not quite clear: are the lines in your example individual records (in the same table?), or does ONE record hold multiple values in both fields?

[klingsc1]

I'm sorry - I should have been clearer. These are two fields in the SAME record. Each field has multiple values (Date Ranges)

[comment]

Try =

ValueCount ( FilterValues ( A ; B ) )

(assuming there are no duplicate values in field A)