Yes, Bob's formula certainly counts dup's as they appear from the top
of the list. Now it's a matter of configuring the formula and
arranging the list. Thanks again.

Michael

On Jun 12, 5:47 pm, "Bob Phillips" wrote:
See my response.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"mcheng" wrote in message

ups.com...



Thanks for the response. What I'm looking for more than a flag, but
rather an assignment of a unique value of where that duplicate occurs
within the series of duplicates. So for example, if Model1234 appears
8 times, the first time would assign the value "1", the second "2",
etc. I found a post corresponding to this, "Nth position of occurence
in a list", and am working with the formula,
=small(if(range=C2,row(range),N)-cell("row",range)+1

However, am in the process of trying to understand the functions
involved...

Thanks again,
Michael

http://groups.google.com/group/micro...orksheet.funct...

On Jun 12, 11:33 am, Duke Carey
wrote:
Let's say the range is C2:C100

Try

=if(countif(C$2:c$100,C2)1,countif(C$2:C2,c2),"No t a duplicated value")

"mcheng" wrote:
Hi, Is there any way to not only count duplicates, i.e.
=COUNTIF(range,C2), but to assign each occurance an ordinal value? So
for example, if Model1234 appears twice within "range", not only would
"2" result, but that the first occurance of Model1234 would display
"1" and the second occurance would display "2".

Any thoughts?

Thanks,
Michael- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -