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.