ranking a data in a field of data

Hi delcroig,

if I understood your question right, you can use RANK function to achieve your goal.

RANK function - Microsoft Support

To automatically rank data in an Excel table, follow these simple steps:

1. Insert a New Column:

   • Right-click on the column next to your data, then click "Insert." This creates a new column for displaying the ranks.

2. Enter the RANK Formula:

   • In the first cell of the new column, type this formula:

=RANK(A2, A$2:A$12)
​

• Replace A2 with the cell containing the data you want to rank.
• Modify A$2:A$12 to cover your entire data range (all 11 data points).

3. Drag the Fill Handle:

• Click and drag the small square at the bottom-right corner of the cell down to apply the formula to all your data points.
  
  

delcroig 

Add a column to the table.

You can use the RANK.EQ function or the RANK.AVG function in a formula in the new column.

It will automatically be propagated to all rows of the table.