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)&"°" |
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...
thank you mse330 thats what i did mean it, i will try your formula.
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 |
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)&"°"