I have data something like this :
a b c d e f g h
12/12/2016 6.00 12 24 29 35 37 49
12/12/2016 9.00 4 8 17 29 37 43
13/12/2016 6.00 1 8 24 29 43 48
I want to count how many repeated in 13/12/2016 6.00 are from 12/12/2016 & 9.00 and 12/12/2016 6.00 seperately and together. I want result is something like
12/12/2016 9.00 separate = 3 ( 8,29,43)
12/12/2016 6.00 separate = 2 (24,29)
12/12/2016 9.00 & 6.00 together (ignoring repeats) = 4 (8,24,29,43)
while counting the nos matching together if it matching 12/12/2016 9.00 I want to create count last repeat count and previous to last repeat (ignoring repeat ) separately and result would be
last repeat count = 3 (8,29,43)
previous to last = 1 ( 24)
kindly guide me
a b c d e f g h
12/12/2016 6.00 12 24 29 35 37 49
12/12/2016 9.00 4 8 17 29 37 43
13/12/2016 6.00 1 8 24 29 43 48
I want to count how many repeated in 13/12/2016 6.00 are from 12/12/2016 & 9.00 and 12/12/2016 6.00 seperately and together. I want result is something like
12/12/2016 9.00 separate = 3 ( 8,29,43)
12/12/2016 6.00 separate = 2 (24,29)
12/12/2016 9.00 & 6.00 together (ignoring repeats) = 4 (8,24,29,43)
while counting the nos matching together if it matching 12/12/2016 9.00 I want to create count last repeat count and previous to last repeat (ignoring repeat ) separately and result would be
last repeat count = 3 (8,29,43)
previous to last = 1 ( 24)
kindly guide me