Auto Match and Numbering in Excel - Thank you...

[clife]

Hi everyone..pleasure to meet..I would like to ask 2 questions..

1. How to create auto numbering in excel and restart on new items. Like the example below:

Data	Automatic number
Red	1
Red	2​
Red​	3​
Blue​	1​
Blue	2​

<thead>
</thead><tbody>
</tbody>

2. Is there any way for excel to automatic math our current data and put it at the side of data that we just paste? Like the example below.

Original Data	Not Like This	Like This
Carrot	Carrot	Carrot
Spinach	Lemon
Lemon	Orange	Lemon
Orange		Orange
Cucumber

<thead>
</thead><tbody>
</tbody>

From the Table above, i just paste carrot, Lemon and orange, despite become on top of the table, the are at the side of the identical data. And if possible, can we set the data just 90% accurate, let say the data is Orangee still sit at the side of orange.




Hopefully somebody can help me. Thank You so much. Sorry for my english.

 

[gaz_chops]

To number use

=COUNTIFS($A$2:A2,A2)

Put in B2 & copy down.

For the 2nd I think you will need VBA.

 

[clife]

To number use

=COUNTIFS($A$2:A2,A2)

Put in B2 & copy down.

For the 2nd I think you will need VBA.

Thank you so much man. Really Works!!!!!!!