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...2778115eaf4d5d
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 -