Rank

rank order data in ExcelThis Analytics Edge wizard is used to convert the selected column into a number representing either the rank order or it’s percentile, decile or quartile position.

It is typically used to segment data or to establish a normalized value for further analysis, such as using Filter and Match to obtain details for the top 10%.

Change Column Into – select a ranking option to use.

Rank – convert the value to a rank number starting at 1 and counting up. Duplicate rows will have the same value, and the next number will be skipped.

Percentile – split the column into 100 ordered groups and convert the value to a number between 1 and 100.

Decile – split the column into 10 ordered groups and convert the value to a number between 1 and 10.

Quartile – split the column into 4 ordered groups and convert the value to a number between 1 and 4.

Order – select whether larger values will rank higher (e.g. counting up), or whether larger values will rank lower (e.g. top 10).

Pick Columns – select the columns by position letter (optionally By Name) to change into a numeric rank column.