First of all hello everyone, new member here.
I'm sure this question was already asked, but I couldn't find it, sorry.

I need to make a sorted copy of my data that updates automatically, so when I change a value in my original table, the other table automatically changes and sorts. The column by which I'd like to sort may contain identical data.

Example:

Original table:

1 cc
2 dd
3 aa
4 cc
5 bb

I need an automatically updating table next to it (or anywhere else):

3 aa
5 bb
1 cc
4 cc
2 dd

(This resulting table doesn't need to be secondary sorted by the first column.)

I could solve this problem using a macro, but I need to solve it using formulas only. Is it possible?

Thank you.