I'd like to build an algorithm that allows me to force rank opportunities... similar to how you can rank your video rentals on the Netflix website.  Example:  If I have 4 opportunities: 

1. MacDonald's

2. Burger King

3. Wendy's

4. Carl's Jr

then I manually elevate the" Wendy's" Opportunity to the top rank I'd want the other Opportunities to automatically re-rank as follows:

1. Wendy's

2. MacDonald's

3. Burger King

4. Carl's Jr

This "Force Ranking" will help me keep our team focused on the most important projects.  Having to manually re-rank opportunities is too time consuming and error-prone, especially when the list is long.  Any advice on how I can achieve this?

Thanks -Tom

I'd like to build an algorithm that allows me to force rank opportunities... similar to how you can rank your video rentals on the Netflix website.  Example:  If I have 4 opportunities: 

1. MacDonald's

2. Burger King

3. Wendy's

4. Carl's Jr

then I manually elevate the" Wendy's" Opportunity to the top rank I'd want the other Opportunities to automatically re-rank as follows:

1. Wendy's

2. MacDonald's

3. Burger King

4. Carl's Jr

This "Force Ranking" will help me keep our team focused on the most important projects.  Having to manually re-rank opportunities is too time consuming and error-prone, especially when the list is long.  Any advice on how I can achieve this?

Thanks -Tom