Reset Continuous Serial Numbers using Rank formula from one Module to Another

Ishan

Dear Experts,

 

I basically want to Reset Serial Numbers in Ascending Order using Rank Formula from the last number (from one module) and start over with the next number (in another module), for example:-

 

In the "ABC" Module, I used the Rank formula:- TEXT(RANK(1, ASCENDING, SEQUENTIAL, Country = Country ZBB.US)) which ended up with the number 18236. Now, in the Module "XYZ", I want to start with the number 18237, please suggest how to reset it, the purpose of doing this is to Export data from both the Modules together into the third Module "123" where I have my non-Numbered List to pull and align the data from both the Modules.

 

Kindly share your expertise on how to do it.

 

Kind regards,

Ishan

Vinay VaradarajM

Hi @Ishan ,

 

You can identify the maximum value from the module ABC (which is 18236 in your example), then add this number to your Rank expression in the module XYZ (the result for 1st entry in XYZ will be 18236 + 1 = 18237). In this way, the Rank values in module XYZ will always add the last number from your module ABC, to give you continuous values.

Hope this helps!