Reset Continuous Serial Numbers using Rank formula from one Module to Another
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.