sheet2 cell a2 to b10 fill country names
&
sheet2 cell b2 to b10 have dates
sheet2 cell a2 to A10 fill country names
&
sheet2 cell b2 to b10 have dates
Cell A2 | Cel B2 |
29_Cluster_02 | |
29_Cluster_07 | |
29_Cluster_11 | |
29_Cluster_07 | |
29_Cluster_07 | |
29_Cluster_02 | |
34_Cluster_11 | |
29_Cluster_02 | |
29_Cluster_01 | |
29_Cluster_02 | |
34_Cluster_10 | |
34_Cluster_03 | |
34_Cluster_09 | |
29_Cluster_07 | |
29_Cluster_07 | |
34_Cluster_13 | |
29_Cluster_14 | |
29_Cluster_07 | |
29_Cluster_07 | |
29_Cluster_12 |
Cell A2 | Cell B2 |
29_Cluster_02 | 2014-06-15 |
29_Cluster_07 | 2014-08-11 |
29_Cluster_11 | 2014-08-22 |
29_Cluster_07 | 2014-08-18 |
29_Cluster_07 | 2014-07-04 |
29_Cluster_02 | |
34_Cluster_11 | 2014-05-29 |
29_Cluster_02 | 2014-07-04 |
29_Cluster_11 | 2014-05-29 |
29_Cluster_02 | 2014-05-29 |
34_Cluster_10 | 2014-08-14 |
34_Cluster_03 | 2014-05-29 |
34_Cluster_09 | 2014-07-04 |
34_Cluster_10 | 2014-07-04 |
29_Cluster_07 | |
34_Cluster_10 | |
29_Cluster_14 | |
34_Cluster_10 | 2014-05-28 |
29_Cluster_07 | 2014-05-28 |
29_Cluster_12 |
try
=COUNTIFS(Sheet2!A:A,Sheet1!A2,Sheet2!B:B,"<>")