Forum Discussion
I have a nine digit number for which the first three numbers determine what team this number belongs
I have a nine digit number for which the first three numbers determine what team this number belongs to. I hve over 800 numbers that begin with the numbers 101 throuhg 129. I have five teams that we ...
It might help to use a helper column. Start a second column and use th formula
=left(A1,3)
and copy it down. then it is very easy to do a countif for each beginning number to count the number of members of each team.
=left(A1,3)
and copy it down. then it is very easy to do a countif for each beginning number to count the number of members of each team.