View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati[_2_] Vasant Nanavati[_2_] is offline
external usenet poster
 
Posts: 45
Default Sorting a 2-dimensional array

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