G Guest May 24, 2004 #1 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.
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 May 24, 2004 #2 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
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
F Frank Kabel May 24, 2004 #3 Hi not really sure what you're trying to do.<could you give an example?
