Sort by formula, keep values in adjacent columns
Posted on 2013-05-22
I would like to sort values in a range consisting of two columns, (see attached sheet), the sort is based on values in column E, and values in F relative to E are kept in same relevant order after the sort. Easy with VBA,
However I'd prefer sorting and keeping the adjacent relevant values using a formula.
Is this possible?