Ha! I was wondering if there is a simple formula Thanks, xld!
Quick question though, how can I replace this "6" (with the quotes) with a cell reference?
If I've got 6 in the B6 cell for example, =SUMPRODUCT(--(MID(A1:A10,2,1)=B6)) won't work
I've figured it out,
it should be =SUMPRODUCT(--(MID(A1:A10,2,1)+0=B6)) for it to work
EDIT: scratch that, it leaves me with the original problem of 1 digit cells, nevermind
Originally Posted by SamT
In VBA, Place the Keyboard cursor inside a word and press F1 for help on that word.