Forum Discussion
how to make the sort function work dynamically/automatically
I have a spreadsheet of values that is sorted by a column that has a formula in it, where the values of that formula come from market inputs etc. Id like my list to sort itself automatically when one of the inputs is changed, rather than manually having to highlight and do the sort instruction each time, is this possible?
Thankyou.
- Use SORT() function.
Thankyou for replying, but I am non the wiser with what to do, am already using the sort function.
AndrewCaris Can you share a sample file via OneDrive or GoogleDrive so that we can understand your problem clearly and provide you best solution? Show your input data and desired output.
