One of the most useful and overlooked tool on the Backoffice is the ability to sort the Unilevel and Personally Enrolled Teams by Rank ID. Rank ID is a numerical system we use to categorize the different Ranks numerical. For instance, 101 refers to the Rank ID for a Member who is unranked (meaning has not placed an order for the month). 102 refers to Associate Rank, 103 to Builder, 104 to Consultant, etc. until it reaches 118 for Royal Crown 2. This is useful because it allows operations involving "Greater than" or "less than" in the spreadsheet on the Backoffice.
For instance, if you wanted to find all Members in your downline who were at least a Consultant, you would enter "104" into the field in the spreadsheet and choose the "is greater than or equal to" metric to find those Members. Note that in the example to the left, we're also pulling up Diamonds, as the Rank ID for Diamonds is "greater than" Consultants (107 > 104).
This functionality is very helpful for determining whether or not you have met your Structural Requirements for Diamond and higher Ranks. Simply set the parameters you want to check (for instance, to check whether you have 3 Consultant Legs, set Rank ID to be greater than or equal to "104", the Rank ID for Consultant Rank). Then, just make sure that at least 3 of the Consultant or higher Members are in separate Legs. The same goes for each Rank where you need to determine if you have met the Structure Requirements. For instance, for Green Diamonds, the requirement is 3 Director Legs. Instead of using the Rank ID "104", just use "105".
An important note...
Paid Rank ID should not be confused with "Rank ID". "Paid Rank ID" refers to the Rank achieved by the Member in the current month, whereas "Rank ID" just refers to the highest Rank achieved by the Member during the course of his or her membership. Therefore, Paid Rank ID is almost always what you want to be using for this purpose.