Replacing values in a table

Hi, I need to replace all numerical values in this table with a ranking of 5 through 1, but I can't use the city names associated with the numbers because my code has to be able to work for different data sets.

         Location           EndAvg  
    ___________________    _________

    'Oklahoma City, OK'    [ 7.5000]
    'Buffalo, NY'          [ 7.8000]
    'Wichita, KS'          [ 8.6000]
    'Rochester, MN'        [ 8.8000]
    'Abilene, TX'          [10.9000]

This is my table, and I need to replace 7.5 with 1, 7.8 with 2, 8.6 with 3, and so on. But say there were 7 cities, I would need it to be ranked from 1-7. How do I get this done?

Answer 1

[Walter Roberson]

[sorted_vals, sortidx] = sort(YourTable.EndAvg);
YourTable.Rank = sortidx;

[Rylan Thronburg]

This doesn’t seem to work, unless I’m just using it wrong.

[Walter Roberson]

The above would create a new variable named Rank in the table. You could replace EndAvg by assigning to YourTable.EndAvg instead of to YourTable.Rank