any idea?

[SBAY3I]

hello all,
how i can do it?
[TABLE="class: outer_border, width: 500, align: center"]
<tbody>[TR]
[TD]1[/TD]
[TD]same nom[/TD]
[TD]same nom 1°[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]same nom
[/TD]
[TD]same nom 2°[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]same nom[/TD]
[TD]same nom 3°[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]same nom[/TD]
[TD]same nom 4°[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]same nom[/TD]
[TD]same nom 5°[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]same nom[/TD]
[TD]same nom 6°[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]other name[/TD]
[TD]other name 1°[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]other name[/TD]
[TD]other name 2°[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]other name[/TD]
[TD]other name 3°[/TD]
[/TR]
</tbody>[/TABLE]

 

[jtakw]

Hi SBAY3I,

I think instead of Just "how do I do this", you need to explain in Detail what data you have before, and what you want to achieve based on what conditions, give samples of before and after, with explanation how the result came about, explain the logic...

 

[mse330]

I am not sure if this is what you really need but I "assumed" that this is what you need :D

Book1
	A	B
1	Original Data	Data with formula
2	same nom	same nom 1
3	same nom	same nom 2
4	same nom	same nom 3
5	same nom	same nom 4
6	same nom	same nom 5
7	same nom	same nom 6
8	other name	other name 1
9	other name	other name 2
10	other name	other name 3
Sheet1

Cell Formulas
Range	Formula
B2	=A2&" "&COUNTIF($A$2:A2,A2)&"°"

 

[SBAY3I]

HI jtakw,
sorry for my bad language, actuly i want to explain more, but some options also in this forum i cant use it well.
thank you mse330 thats what i did mean it, i will try your formula.

Hi SBAY3I,

I think instead of Just "how do I do this", you need to explain in Detail what data you have before, and what you want to achieve based on what conditions, give samples of before and after, with explanation how the result came about, explain the logic...

 

[mse330]

thank you mse330 thats what i did mean it, i will try your formula.

Glad to help, you are welcome

 

[SBAY3I]

hi MSE330
doesnt works with me

Glad to help, you are welcome

 

[Aladin Akyurek]

Book1
	A	B
1	same nom	1
2	same nom	2
3	same nom	3
4	same nom	4
5	same nom	5
6	same nom	6
7	other name	1
8	other name	2
9	other name	3
Sheet1

In B1 enter and copy down:

=COUNTIFS($A$1:A1,A1)

If this is not what you want, try to post a real input and the corresponding desired output.

 

[SBAY3I]

hello
https://1drv.ms/x/s!As8Mdv-a95REhTivKZr5Dz_GRFUP
i have a lot of names i cant do it with all names one by one

 

[mse330]

Insert the below formula in D8 & then double click using the mouse on the lower right edge of the D8 cell & the formula will be copied all the way to the last row

=C8&" "&COUNTIF($C$8:C8,C8)&"°"

 

[SBAY3I]

hi
i will try it too thank you very much

Insert the below formula in D8 & then double click using the mouse on the lower right edge of the D8 cell & the formula will be copied all the way to the last row

=C8&" "&COUNTIF($C$8:C8,C8)&"°"