Hi everyone, I hoping someone could help me. I would like to count distinct telephone numbers but only if they don't start +443, for these I just want to count the total and then add the 2 figures together.
+447411912345
+447411912345
+441908543211
+443456002312
+447974343211
+447845312345
+443456002312
So for the data above, I would like the answer to be 6, 4 distinct non +443 numbers, and 2 +443 numbers.
Kind regards