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
|