# How to Use the RANK Function in Excel

- URL: https://betteranalyst.com/excel/rank-function
- Author: Better Analyst

### Descending rank

```excel
=RANK.EQ(B2,$B$2:$B$6,0)
```

Ranks the largest value as 1.