Show number of an occurrence?

[kruuth]

Is there a way to show an occurrence number in excel with a list of data and dates? In this case I have a bunch of license plates, and dates. I sort on the dates. I'd like to have a third column that shows the number of times that plate has shown up prior to that date in the month so it looks like this:

License--Date--Occurence
XXX-XXX--5/1/11--1
AAA-AAA--5/1/11--1
XXX-XXX--5/5/11--2
BBB-BBB--5/6/11--1
XXX-XXX--5/12/11--3

Is there a way to do something like this?

 

[Aladin Akyurek]

Is there a way to show an occurrence number in excel with a list of data and dates? In this case I have a bunch of license plates, and dates. I sort on the dates. I'd like to have a third column that shows the number of times that plate has shown up prior to that date in the month so it looks like this:

License--Date--Occurence
XXX-XXX--5/1/11--1
AAA-AAA--5/1/11--1
XXX-XXX--5/5/11--2
BBB-BBB--5/6/11--1
XXX-XXX--5/12/11--3

Is there a way to do something like this?

In C2 enter & copy down:

=SUMPRODUCT(--($A$2:A2=A2),--($B$2:B2=B2))

If you are on 2007 or later, invoke

=COUNTIFS($A$2:A2,A2,$B$2:B2,B2)

instead.

 

[Ron Coderre]

With your sorted, sample data in A1:B6
this regular formula increments the count of the referenced License value

C2: =COUNTIF(A$1:A2,A2)

Is that something you can work with?

 

[kruuth]

That did it. Thanks.