Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup within a 2 dimensional array | Excel Worksheet Functions | |||
Sorting a Two Dimensional Table | Excel Discussion (Misc queries) | |||
2-dimensional array to 2 column list | Excel Discussion (Misc queries) | |||
How do I convert a row of cells into a two-dimensional array? | Excel Worksheet Functions | |||
Three Dimensional Array Question | Excel Discussion (Misc queries) |