Excel Formulas to specify the Rank for Racing Result ~ Quick Tricks!!
Tags: excelformula, excelformulas
Published: 2021-04-21 07:36:45

---
title: Excel Formulas to specify the Rank for Racing Result ~ Quick Tricks!!
published: true
date: 2021-04-12 04:42:08 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-specify-the-rank-for-racing-result-quick-tricks/
---

Using a ranking method you can easily announce the ranks for all or some participants according to any kind of metrics that can be calculated. These ranks can then be used in lists, certificates, or in any other part of the software. In this article, I introduce some formulas which can quickly specify the **rank for racing times in Excel**. Let’s get started!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Formula to rank ranking result](https://geekexcel.com/wp-content/uploads/2021/04/Formula-to-rank-ranking-result.png)](https://geekexcel.com/excel-formulas-to-specify-the-rank-for-racing-result-quick-tricks/formula-to-rank-ranking-result/#main)<figcaption id="caption-attachment-22904">Formula to rank ranking result</figcaption>

## General Formula:

- Use the below formula to rank a set of race times in Excel.

**=[RANK](https://geekexcel.com/how-to-use-excel-rank-function-in-office-365-with-examples/)(time,times,1)**

## Syntax Explanations:

- **RANK**  – This function will return the rank of a number from a list of numerical values. Read more on the **[RANK Function](https://geekexcel.com/how-to-use-excel-rank-function-in-office-365-with-examples/)**.
- **Times** – It specifies the input range from your worksheet.
- **Time** – It represents the input value.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Refer to the below example image.

- First, we will enter the input values in  **Column B**  and  **Column C**.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/04/Input-Ranges-12.png)<figcaption id="caption-attachment-22905">Input Ranges</figcaption>

- Then, apply the above-given formula to the [**formula bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section and press the  **ENTER**  key.

![Enter the formulas](https://geekexcel.com/wp-content/uploads/2021/04/Enter-the-formulas.png)<figcaption id="caption-attachment-22903">Enter the formulas</figcaption>

- Finally, we will get the result in the selected cell as shown in the below image.

![Result](https://geekexcel.com/wp-content/uploads/2021/04/Result-12.png)<figcaption id="caption-attachment-22906">Result</figcaption>

## Bottom-Line:

Here, we have described the simple formula to specify the **rank for racing times in Excel**. Please feel free to state your **query** or **feedback** for the above article. Thank you so much for visiting our site!! Click here to know more about **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Also:

- [**Excel Formulas to Calculate the Average of Last N Numeric Values!!!**](https://geekexcel.com/excel-formulas-to-calculate-the-last-n-numeric-values/)
- **[Excel Formulas to Count Unique Numeric Values with Criteria!!](https://geekexcel.com/excel-formulas-to-count-unique-numeric-values-with-criteria/)**
- **[How to Remove Numeric Characters From a Cell in Excel? ~ Easy Tutorial!!](https://geekexcel.com/remove-numeric-characters-from-a-cell/)**
- **[Excel Formulas to Highlight the Values Not Between X and Y!!](https://geekexcel.com/excel-formulas-to-highlight-the-values-not-between-x-and-y/)**