Hi Annie,

Say your ABC/XYZ values are in columns A & B:
Enter in C1:
=A1&"-"&B1&"-"&TEXT(SUMPRODUCT((A$1:A$1=A1)*(B$1:B1=B1)),"0 00")
and drag down


HTH
--
AP

"Annie" a écrit dans le message de news:
...
All,

I have a need to create an alphanumeric value that is a combination of two
alpha values and an incremented number off of existing data. For
instance:

ABC-XYZ-001
ABC-XYZ-002
ABC-XYZ-003

The alpha values already exist in two separate fields. I have not done a
count or increment. I suspect what I need to do is to get each instance
of
the ABC-XYZ to increment and then concatenate this new field together.

I've got the concatenate - I"m just not sure I'm finding a formula that
will
count each record that has the ABC-XYZ combination - and I have ABC-LMN's
as
well - the combinations are vast - I need to count when how many each
combination appears...
Thoughts?