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
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?
Correct Nick93
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")
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
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"))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thanks very much all!
You're welcome and thanks for the Rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks