Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, please help me. How to assign a number in the script and in the diagram, as in the example shown. I tried to use the function "autonumber" and "rank" failed.
Example:
Thank you in advance.
@Nextle ,
What is the criteria for assigning a number.
if the work of one surname = the work of another surname, their numbers are the same, and the next number is the previous +1. At the same time, in each new month, the rank starts from 1.
Use RANK function on Work+Month this might resolve the issue.