Unique data count sequence

[Remalay]

Hey guys,

is there a formula I can use that will look at the data in col.A & col.B then in col.C numerically sequence each time there is match for each occurrence?
eg

Mar Mon 1
Mar Tue 1
Mar Mon 2
Apr Mon 1
Mar Tue 2
Mar Mon 3
Mar Mon 4
Apr Mon 2
Mar Tue 3
etc

Thanks in advance.

 

[Ron Coderre]

It's important to post the version of Excel that you are using so we can offer solutions that are compatible with your environment.

With your sample data beginning in cell A1...

Excel 2007 and later
This regular formula begins the count of occurrences

C1: =COUNTIFS(A$1:A1,A1,B$1:B1,B1)

Pre-Excel 2007

C1: =SUMPRODUCT(--(A$1:A1=A1),--(B$1:B1=B1))

Copy either formula down as far as you need.

Does that help?

 

[Remalay]

Re: Unique data count sequence - SOLVED

Ooops, sorry about the oversight.

I'm running 2007 and it works a treat, thanks Ron.

rgds
Remalay