Forum Discussion
Solved
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...
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.
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.
- thanks