LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #10   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default Sort on two columns in two dimensional array

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Do I need a two dimensional array for this? hotherps[_17_] Excel Programming 1 February 20th 04 04:46 PM
2 Dimensional Array steve Excel Programming 0 August 18th 03 07:19 PM
Beginners' Question : How to move selected columns & rows to a two dimensional array Erche DP Excel Programming 3 July 18th 03 03:25 PM
Beginners' Question : How to move selected columns & rows to a two dimensional array Erche Excel Programming 4 July 18th 03 04:19 AM
sort multi-dimensional array on numeric data? RB Smissaert Excel Programming 0 July 14th 03 10:49 PM


All times are GMT +1. The time now is 03:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"