Table of Contents
🔹 Use the RANK Function to Find Position in a List
📌 Formula:
=RANK(C6, $C$6:$C$30)
🔹 Explanation:
- C6 → The cell you want to rank.
- $C$6:$C$30 → The range of values where ranking is applied.
- This formula assigns a rank based on the highest value (default descending order).
🔹 Example Output:
| Score (C) | Rank |
|---|---|
| 95 | 1 |
| 87 | 2 |
| 75 | 3 |
| 65 | 4 |
✅ Use this for rankings in competitions, sales data, and performance analysis! 🚀
