Auto Match and Numbering in Excel - Thank you

Status
Not open for further replies.
C

cliffe

New member
Joined
Feb 17, 2019
Messages
2
Reaction score
0
Points
0
Excel Version(s)
Office 365
[FONT=&quot]Hi everyone..pleasure to meet..I would like to ask 2 questions..[/FONT]

  • How to create auto numbering in excel and restart on new items. Like the example below:
[FONT=&quot]
[/FONT]
Red1
Red2
Red3
Blue1
Blue2
[FONT=&quot]
[/FONT]
[FONT=&quot]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.[/FONT]
[FONT=&quot]
[/FONT]
Original DataNot Like ThisLike This
CarrotCarrotCarrot
SpinachLemon
LemonOrangeLemon
OrangeOrange
Cucumber
[FONT=&quot]From the Table above, i just paste carrot, Lemon and orange, despite become on top of the table, the are on the side of the identical data. And if yes, can we set the data just 90% accurate, let say the data is Orangee still sit at the side of orange.[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]Hopefully somebody can help me. Thank You so much. Sorry for my english.[/FONT]
 
CROSS POST


This question has been posted in at least one other forum.
Do not post any further responses in this thread until a link has been provided to these cross posts.

Whilst we would rather you didn't cross-post, we know that there may be a valid reason for doing so. All we ask is that you provide the links in your original post to your question in the other forum(s). Read this to understand why: https://www.excelguru.ca/content.php?184



This forum is full of volunteers that give up their own time to help others, something that should be respected and not taken for granted. It’s never nice for someone to find out that a problem they have spent time solving for you has already been answered somewhere else without them knowing, and so we ask you to make it clear that you have also asked elsewhere.

Please update your original post to include the link(s).
 
Status
Not open for further replies.
Back
Top