# check datasets and match

1. ## check datasets and match

Hey,
I am having trouble to calculate if two different datasets are not matching but dataset 2 is laying within the value of dataset 1.
File with 4 examples attached.

Normally I would have if dataset match 100 % that one I can do.
But in this case all i need to know is if the dataset 2 datapoint are laying within dates that dataset 1 has values for.

2. ## Re: check datasets and match

So let me get this straight.
Dataset A and Dataset B match if and only if, for every X in Dataset B there's an X in Dataset A? Or, to put it another way, if for every X in dataset B there's an X above it? Am I understanding it correctly?

3. ## Re: check datasets and match

Correct Nick93

4. ## Re: check datasets and match

In P9, then copy to P14, P19 and P25.

=IF(SUM(IF((\$D9:\$O9="X")*(\$D8:\$O8="X"),1,0))=COUNTIF(D9:O9,"X"),"YES","NO")

5. ## Re: check datasets and match

I'm not sure exactly what result you expect to see, as you didn't tell us.

Maybe this, a count of the number of matching X's per pair of datasets, in B8, copy pasted into B13, B18, etc:

=SUMPRODUCT((D8:O8="X")*(D9:O9="X"))

6. ## Re: check datasets and match

Thanks very much all!

7. ## Re: check datasets and match

You're welcome and thanks for the Rep.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1