View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mcheng mcheng is offline
external usenet poster
 
Posts: 10
Default duplicate occurance, assigning an ordinal value

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