Forum Discussion
help with formula
Im trying to auto sort a column by descending order, but I need the column next it to move with it, ex one column has names, the next has hours worked. When the hours are worked I need the names and hours to auto sort
Let's say your data are in D2:E500.
In a cell elsewhere:
=SORT(D2:E500, 2, -1)
will return the data sorted descending on hours worked.
You mention "auto sort".
Do you want the data to be sorted automatically in place, or do you want to return the sorted data in another location?
Let's say your data are in D2:E500.
In a cell elsewhere:
=SORT(D2:E500, 2, -1)
will return the data sorted descending on hours worked.
