Sweet, I figured it out. CountIF is the formula I wanted. Thanks for the help Everyone
Printable View
Sweet, I figured it out. CountIF is the formula I wanted. Thanks for the help Everyone
=countif(a1..a22,"101"*)
will give you the number of times 101xxxxx appears in the cell range a1 to a22
you might have to play with the " and decide if that's a number or text field
you might not need the " at all.
but that's what you are looking for. there's a good help on countif in excel. (and yes, used to use this a lot for doing exactly what you say)
shit
beat by one minute
Have to write a script to sort and count. Not one of their built-in functions will do this that I know of.
Edit: There you go. A function I wasn't aware of.
No more help needed. Everything is working and this is pretty awesome. Thanks Everyone. If anyone is curious, here is the formula I set up: =COUNTIF(A2:A1000,10x2011) Where x is 1 for the 101 column, 2 for the 102 column.. etc