# 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.

Ask if its unclear   Register To Reply

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?  Register To Reply

3. ## Re: check datasets and match

Correct Nick93  Register To Reply

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")  Register To Reply

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"))  Register To Reply

6. ## Re: check datasets and match

Thanks very much all!  Register To Reply

7. ## Re: check datasets and match

You're welcome and thanks for the Rep.  Register To Reply