Forum Discussion

Thomas McKissick's avatar
Thomas McKissick
Copper Contributor
Jul 13, 2017

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 ...
Formulas & Functions
Need Help
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Jul 13, 2017

Hello Thomas

 

Are you looking for something like this?

=COUNTIFS(A1:A100,">=101000000",A1:A100,"<102000000")
  • Thomas McKissick's avatar
    Thomas McKissick
    Copper Contributor
    Jul 13, 2017

    I'll try it and let you know.

    Thanks!

Resources