Hi everyone!
I have a table like this one below:
figure 1
What I need as result is a rank of the stores by the largest Accumulated Money (which is the sum of the column “money” grouped by store).
As you can see, some people are attended by more than one store, therefore I need to perform a loop to sort the stores by the Accumulated Money, select the first one and copy its value to the rank sheet, then eliminate the “already attended persons” from the others stores, and sort again the remaining stores. And keep repeating this process until all stores are ranked.
figure 2
This is the workflow I’ve created, and I don’t know how to link the “False” values back to the beginning to repeat the process. I’ve watched the Macro’s videos and searched through the community, but I couldn’t make it work properly.
Can someone, please, help me with this matter?
Thank you!
