---
title: Rank Column
description: Ranks all values in a column based on the method chosen
---

[Back to home](https://www.flow-wizard.com/knowledge)

- [ Analytical 
  
  ](https://www.flow-wizard.com/knowledge/analytical)
- [ Arithmetic 
  
  ](https://www.flow-wizard.com/knowledge/arithmetic)
- [ Data Prep 
  
  ](https://www.flow-wizard.com/knowledge/data-prep)
- [ Logical 
  
  ](https://www.flow-wizard.com/knowledge/logical)
- [ Charting Functions 
  
  ](https://www.flow-wizard.com/knowledge/charting-functions)
- [ Date Time 
  
  ](https://www.flow-wizard.com/knowledge/date-time)

# Rank Column

## Ranks all values in a column based on the method chosen

***Function:***

Rank(table = *string*, col =* string*, new_col = *string*, method = *string*)

 

***Parameters:***

*Table: *Table name on which to perform function

*Column (col): *Column to perform Rank

*Method: *How to rank the group of records that have the same value,

- **first:** ranks assigned in order they appear,
- **min:** will rank values as the same

*New Column Name: *Name for New Column

 

***Examples:***

Rank(table = Budget, col = "Amount", new_col = "Amt. Ranked", method = "first")