Glenn, I need the formula to indicate the total number of items in that
series, i.e., between the starting series number (S2M478) and the ending
series number (S24890). The third column I added below indicates the correct
number of items, but it has been calculated manually. I'm hoping a formula
will indicate the same total.

"Glenn" wrote:

TeeTee wrote:
I am trying to set up an inventory report for items which have serial
numbers, but have little experience with complicated formulas. The three
columns of the worksheet contain the starting number, the ending number and
the total in stock for each series. However, most of the serial numbers
contain letters, for example:

S2M478 S2M489 12
XV918N XV999N 82
DG12325 DG12339 15
9B2J8 9B9J9 72
AB280CC AB309CC 30

Is there a formula that will work with both numbers and letters? Id
appreciate any help. Thanks.



A formula to do what?