auto sort in real time

J

jm0572

I used the formula to sort one column eg =large($a$1:$a$50, row()), is there a way to sort two columns? Where the amount in A1 matches the text in A2.
 
R

RagDyer

The formula you're using does *not* sort your numerical data.
It just *appears* that it does, (in the "helper" column)!

You're *original* data (A1:A50) didn't move,
SO ... adjoining columns wouldn't move either.

--


Regards,

RD
 
Top