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.
Bookmarks