In this article, we’re going to show you 3 methods of how to Stack Rank employees in Excel. To demonstrate our solutions, we’ll be using a dataset containing 4 columns: “Name”, “Work Pace”, “Quality of Work”, and “Attendance”.

**Table of Contents**hide

## How to Stack Rank Employees in Excel: 3 Easy Ways

### 1. Using RANK Functions to Stack Rank Employees in Excel

For the first method, we’ll be using **the RANK function** to Stack Rank Employees.

We’ll take the individual scores and using the assigned weights we’ll find the overall score. Then, we’ll use the **RANK** function to reach our goal.

**Steps:**

- Firstly, type the following formula in cell
**F5**.

`=(C5*$C$13)/100+(D5*$C$14)/100+(E5*$C$15)/100`

Our total scale of the weights is 100. We’re dividing it with the weight and multiplying it with the employees’ scores.

- Secondly, press
**ENTER**.

We’ve got our weighted score of all the criteria.

- Thirdly, press
**ENTER**and**AutoFill the formula**into the rest of the cells. - Then, type this formula to cell
**G5**.

`=RANK(F5,$F$5:$F$10)`

The **RANK** function returns the position of a number in a range. We’re finding out the position of 58 in the range **F5:F10**.

- After that, press
**ENTER**.

Here, we’ve got 2 as the position of 58 in that range.

- Finally,
**AutoFill**the formula.

Thus, we’ve got the Stack Rank of the employees in Excel. The weight was unequal, and we got “Nolan” as the best employee.

**Read More: Ranking Data in Excel with Sorting**

### 2. Stack Rank Employees in Excel by Merging SUMPRODUCT & RANK Functions

For the second method, we’re going to use **SUMPRODUCT** & **RANK** functions to Stack Rank Employees. Moreover, the weights are given in percentage format.

Here, we’ll get the overall scores by using the assigned weights in the **SUMPROUDCT** function, after that, we’ll use the **RANK** function to find the best employee.

**Steps:**

- Firstly, type the following formula in cell
**F5**.

`=SUMPRODUCT(C5:E5,$B$14:$D$14)`

The **SUMPRODUCT** function multiplies a range of numbers and returns the sum of those numbers. Our formula basically does this -> **C5*B14 + D5*C14 + E5*D14**.

- Secondly, press
**ENTER**.

This will return the weighted total score of the employees.

- Thirdly,
**AutoFill**the formula. - Then, type another formula from below to cell
**G5:G10**.

`=RANK(F5,$F$5:$F$10)`

The **RANK** function returns the position of a number in a range. We’re finding out the position of 56 in the range **F5:F10**.

- Finally, press
**CTRL + ENTER**.

In conclusion, we’ve got the Stack Rank of the employees in Excel. The weight was inequal, and we got “Nolan” again as the best employee.

**Similar Readings**

**How to Rank Within Group in Excel****How to Rank with Ties in Excel****How to Calculate Rank Percentile in Excel****Rank IF Formula in Excel****How to Calculate Top 10 Percent in Excel**

### 3. Use of Combined Functions for Equal Weight to Stack Rank Employees

For the final method, we’re going to use the **SUM**, **COUNTIF** & **RANK** functions to Stack Rank employees. This time, we’re considering equal weight for the criteria.

Moreover, we’ll rank** **the employees on each criterion, and lastly, R1, R2, and R3 refer to the Ranking of the individual score in the respective criteria.

**Steps:**

- Firstly, type the following formula in cell
**C13**.

`=RANK(C5,C$5:C$10)+COUNTIF(C$5:C5,C5)-1`

- We’ve two parts to this formula.
- The first one is the
**RANK**function, which returns the position of a number in a range. We’re finding out the position of 50 in the range**C5:C10**. - The second one is the
**COUNTIF**function, which counts cells with a defined condition. - We’re using this to eliminate any duplicate positions in the
**Rank**. Moreover, we’re subtracting**1**to stop our formula from adding when there is no duplicate.

- Secondly, press
**ENTER**.

This will show the position of 50 in our range.

- Then,
**AutoFill**the formula. - After that, use the
**Fill Handle**to**AutoFill**the formula to the right side.

We’ll get the position of the rest of the cells.

- After that, type this formula into the cell range
**F13:F18**.

`=SUM(C13:E13)`

The **SUM** function performs an addition operation. This is the operation: **C13 + D13 + E13**.

- Then press
**CTRL + ENTER**.

This will **AutoFill** the formula.

- After that, type this formula in cell
**G13**.

`=RANK(F13,$F$13:$F$18,1)+COUNTIF(F$13:F13,F13)-1`

This **formula is similar to the formula just above**.

- Finally, press
**ENTER**and**AutoFill**the formula.

Thus, we’ve shown you the final method of Stack Rank employees with equal weight to the criteria.

## Practice Section

We’ve provided practice datasets for each method in the Excel file.

**Download Practice Workbook**

## Conclusion

We’ve shown you 3 methods of how to Stack Rank employees in Excel. If you face any problems, feel free to comment below. Thanks for reading, keep excelling!