Google Driive calc - Assign correlative numbers 1, 2,   to a equal codes

Posted on 2016-08-03
Medium Priority
Last Modified: 2016-08-03

I would like to know if ther is any formula to automatically assign the same correlative number to equal or repetitive codes.

For column  ORDEN is there any  formula to assing the same number to ORDEN for each equal Ordernumber as in this example?
That is ORDEN 1 for all repetied order 200001195
ORDEN 2 for all repeted order 200001198

ORDEN      Ordernumber
1      200001195
1      200001195
1      200001195
2      200001198
2      200001198
3      100005020
3      100005020
3      100005020
3      100005020

Thanks again
Question by:apocalip30
LVL 54

Accepted Solution

Rgonzo1971 earned 2000 total points
ID: 41740397

Pls enter a 1 at line 2
at line 3 this formula

Open in new window

and fill down


Author Closing Comment

ID: 41740417
Thanks !!
LVL 18

Expert Comment

ID: 41740421
If these are not in sequence the formula above will not work.
It would be preferable to put unique ORDEN and Ordernumber combinations into a separate sheet and use a vlookup statement to fill in the ORDEN based on exiting Ordernumber values in that lookup sheet.
If there is no such number, the next number will be automatically assigned.
However, in this case do not forget to add the new unique ORDEN and Ordernumber combination to the lookup sheet and update the lookup reference in the formula

Check the example I've attached.

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question