Macro to display output

[pratheepm7]

Hi Guys,

I need help in macro. I have example value in column A and i need output like below. could you pls help for below output

Ex :
US
US
US
UK
UK
UK

output :
Info-US-1
Info-US-2
Info-US-3
Info-UK-1
Info-UK-2
Info-UK-3

[Arkadi]

Assuming data starts in A1, you could paste this formula in B1, and then copy down

Please Login or Register  to view this content.

[mike7952]

And a vba solution

Please Login or Register  to view this content.

[popipipo]

Please Login or Register  to view this content.

This will also work

[pratheepm7]

And a vba solution

Please Login or Register  to view this content.

Hello Mike

Thanks for the code it's reflecting the exact output I want

[mike7952]

There are some good formula examples also that work perfectly too. If this takes care of your needs please mark thread solved.