Need help with excel formula or program

[motorcyclemarket]

Here is my situation:
Data I have Data I need
[TABLE="width: 500"]
<tbody>[TR]
[TD]1000[/TD]
[TD]1000_1[/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD]1000_2[/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD]1000_3[/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD]1000_4[/TD]
[/TR]
[TR]
[TD]2000[/TD]
[TD]2000_1[/TD]
[/TR]
[TR]
[TD]2000[/TD]
[TD]2000_2[/TD]
[/TR]
[TR]
[TD]3000[/TD]
[TD]3000_1[/TD]
[/TR]
[TR]
[TD]3000[/TD]
[TD]3000_2[/TD]
[/TR]
[TR]
[TD]3000[/TD]
[TD]3000_3[/TD]
[/TR]
[TR]
[TD]4000[/TD]
[TD]4000_1[/TD]
[/TR]
</tbody>[/TABLE]


Is there a formula to give me the end result in column 2 from column one?

Neil Ghuman

 

[Marcílio_Lobão]

motorcyclemarket, Good afternoon.

Suppose your data is at column A at A1:A100

Do it:

B1 --> =A1&"_"&COUNTIF($A$1:A1,A1)

Copy it down.

Tell us if it worked for you.
I hope it helps.

 

[motorcyclemarket]

motorcyclemarket, Good afternoon.

Suppose your data is at column A at A1:A100

Do it:

B1 --> =A1&"_"&COUNTIF($A$1:A1,A1)

Copy it down.

Tell us if it worked for you.
I hope it helps.

This worked awesome. Thank you, thank you, thank you, thank you!!!!!!

 

[Marcílio_Lobão]

I feel glad to help you.

Greetings from Brazil
------------------------------
Belo Horizonte, Brasil
Marcílio Lobão