I'm looking for a formula that I can enter to do this for
me automatically so I don't have to do Data-Sort
everytime the data changes. I specifically chose Col D to
show the two columns are not adjacent.


-----Original Message-----
Maybe he means a 2-D array rather than a range; though
Col A and Col D
do look suspiciously like a range.

Alan

Vasant Nanavati wrote:
Hi Randy:

Is it column D or column B? In any event, you can sort
from the menu using
Data | Sort and specify which column you want to sort
on. Perhaps I'm
missing the point.

Regards,

Vasant.

"Randy S" wrote in message
...

How do I sort a 2-dimensional array from a formula? If I
have 2 columns of data:

Col A Col D
Joe Smith $4.24
Jane Doe $2.48
Fred Flint $8.88
John Stein $1.89


I want to sort both columns based on values in Col B, so
I'd end up with:

Col A Col D
Fred Flint $8.88
Joe Smith $4.24
Jane Doe $2.48
John Stein $1.89




.