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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set up and printing a 4-up mail merged postcard 0
Work Budget Salary vs Real Time Salary 0
Sort Issue Excel 2003 1
Calculate end date and time 1
adding multiple values from matched search results 3
Trying to count based on multiple criteria & cell comparisons 4
Hyperlinks with lookups 0
Excel 2000 formula to dynamically sum adjacent rows and columns whererows inserted/deleted 3

Top