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?

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?

What is the sequence of numbers between 9B2J8 and 9B9J9 (you don't have to
list them all, but give us an idea how they "count" up)? Also, where is the
data that you want counted (that is, how is your data laid out)?

--
Rick (MVP - Excel)


"TeeTee" wrote in message
...
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?

What is the sequence of numbers between 9B2J8 and 9B9J9

Could be either 928 to 999 or 28 to 99.

I'll pass on this one! <g

--
Biff
Microsoft Excel MVP


"Rick Rothstein" wrote in message
...
What is the sequence of numbers between 9B2J8 and 9B9J9 (you don't have to
list them all, but give us an idea how they "count" up)? Also, where is
the data that you want counted (that is, how is your data laid out)?

--
Rick (MVP - Excel)


"TeeTee" wrote in message
...
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? I'd
appreciate any help. Thanks.



A formula to do what?