apocalip30
asked on
Google Driive calc - Assign correlative numbers 1, 2, to a equal codes
Hi,
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
Example_Orden.xlsx
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.
Example_Orden.xlsx
ASKER