Sequence numbering for each duplicate record

Hi,

Requesting hlep. This is the first time I am posting to this forum. I am using Excel 2007.

I want to number each duplicate record sequentially which is having same data in all the columns. Please find the example below:

I have shown the sequence number the way I want in the last column.


74 ACP MCTO 0227802 1
74 ACP WC 0227802 1
74 ACP MCTO 0227802 2
74 ACP WC 0227802 2
74 ACP MCTO 0227802 3
74 ACP WC 0227802 3
74 ACP MCTO 0227802 4
74 ACP WC 0227802 4
74 ACP MCTO 0227802 5
74 ACP WC 0227802 5
72 ACP MCTO 0082206 1
72 ACP WCD 0082206 1
72 ACP WC 0086576 1
72 ACP WC 0086576 2


Thanks in advance.

Originally Posted by jeffreybrown

Hello & Welcome to the Board,

In F1 copied down...

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

Hi Jeff... Thank you very much for your quick responce. Its working fine as required.

Thanks alot.