Below is the output i get from a data base.

A | 1 |

B | 2 |

C | 1 |

D | 1 |

A | 2 |

B | 1 |

C | 3 |

D | 4 |

B | 6 |

C | 5 |

D | 3 |

A | 3 |

A | 4 |

B | 3 |

C | 2 |

D | 2 |

Is there a way I could automatically rank them as show below. This output will be in a sheet and I will have the Alphabets static but I want the numbers to automatically update based on their rank

A | 1 |

A | 2 |

A | 3 |

A | 4 |

B | 1 |

B | 2 |

B | 3 |

B | 6 |

C | 1 |

C | 2 |

C | 3 |

C | 5 |

D | 1 |

D | 2 |

D | 3 |

D | 4 |

Any help is appreciated.

Thanks!