Auto update and Show "Sort By" in Cell

[mattyj7183]

Hello,

I have my data in a table 5 columns wide going from A3:E3 (below)

Account Name

Account Type

State

City

Distance from Office

I would like A2 to automatically show the current "sorted by" that is being used in the table. For instance, if sorted my table by City from A to Z, I would like A2 to say something like "Sorted by City A to Z". Similarly, if I sorted by Distance from Office looking for the clients who lived the farthest, I would like A2 to say something like "Sorted by Distance From Office Largest to Smallest."

Thanks in advance!