Home |
Search |
Today's Posts |
#10
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi David,
Thanks for the message - as per Toms suggestion (thanks!), I ended up dumping the data to a worksheet and doing a data sort on it before reading it back in. Cheers, Al "David Fixemer" wrote in message ... Al, I've read all of Tom's and your comments and it appears you two either have it worked out, or will get it worked out. That is greate considering I didn't even understand the problem. Overnight (Drive Home) I considered your problem a little more. Your reply simply reinforced my conculsions. My previous post had the elements already in order. If it actually looked like this: | 1 | 2 | 3 | 4 -+------------+------------+------------+------------ 1| Entry1 | Entry11 | Entry10 | Entry4 -+------------+------------+------------+------------ 2| Entry5 | Entry3 | Entry2 | Entry8 -+------------+------------+------------+------------ 3| Entry9 | Entry7 | Entry6 | Entry12 Then you would desire a list like one of the following, depending on weather you sort by row or column first? Entry1 Entry1 Entry4 Entry5 Entry10 Entry9 Entry11 ------- ------- Entry3 Entry2 Entry7 Entry3 Entry11 Entry5 ------- Entry8 Entry2 ------- Entry6 Entry6 Entry10 Entry7 ------- Entry9 Entry4 Entry12 Entry8 Entry12 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Do I need a two dimensional array for this? | Excel Programming | |||
2 Dimensional Array | Excel Programming | |||
Beginners' Question : How to move selected columns & rows to a two dimensional array | Excel Programming | |||
Beginners' Question : How to move selected columns & rows to a two dimensional array | Excel Programming | |||
sort multi-dimensional array on numeric data? | Excel Programming |