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...

Please Login or Register  to view this content.

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

Thanks alot.