A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.

At the sheet level, conditional running totals require focused expressions, but an Excel PivotTable requires only a few field swaps. Susan Harkins shows you how.

To solve this problem, Excel allows conditional calculations so that you can calculate the normal rate for up to 40 hours worked and then a higher amount for overtime hours worked. Open a new ...

7. Click ‘OK’ twice to apply conditional formatting. 8. Observe that Excel highlights the cell with the formula mentioned in the Method 1, indicating the percent difference. Conclusion: Regardless of ...