clarkebball22
New Member
- Joined
- Aug 11, 2014
- Messages
- 16
I have the table below. I would like to automatically rank these in the next columns (F-H). The first column is automatically ranked (already know the formula). Second column is names, 3rd column is companies sold, 4th column is internal information and the 5th column will be total employees at each of the companies. What is the formula to automatically put them in order from most companies sold (tie breaker of total employees)?
<tbody>
</tbody>
Ranks | Names | Companies | Internal | Employees |
3 | Name 1 | 12 | 120 | |
5 | Name 2 | 8 | 80 | |
7 | Name 3 | 4 | 40 | |
1 | Name 4 | 15 | 150 | |
2 | Name 5 | 12 | 124 | |
4 | Name 6 | 9 | 90 | |
6 | Name 7 | 6 | 60 |
<tbody>
</tbody>