How to Match data side by side and auto numbering in Microsoft Excel

[cliffe]

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:

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.




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.

 

[AliGW]

Cross-posted:

https://www.excelforum.com/excel-fo...264854-auto-numbering-in-excel-thank-you.html

https://www.ozgrid.com/forum/forum/...by-side-and-auto-numbering-in-microsoft-excel

https://www.excelguru.ca/forums/showthread.php?9817-Auto-Match-and-Numbering-in-Excel-Thank-you

https://www.mrexcel.com/forum/excel-questions/1087790-auto-match-numbering-excel-thank-you.html

 

[vletm]

cliffe
Did You read this?
https://chandoo.org/forum/forums/new-users-please-start-here.14/

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an answer elsewhere, have the courtesy of posting the answer here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.

or same kind of rules from other sites?

Next ... follow rules!