LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 43
Default Question for Alan on QuickSort

Alan -

Two questions:

1) I think I finally figured out why I'm having trouble sorting one of
my arrays using your great routine - but maybe you can confirm. Does
quicksort only work with arrays that are greater than 1D? I had an
array that was something as follows:

aRay(0) = "100000"
aRay(1) = "100100"
aRay(2) = "100200"
aRay(3) = "100250"
etc.

When I tried to used QuickSort with the following code:

QuickSort aRay, 1, LBound(aRay,1), UBound(aRay,1), True
I ended up getting a subscript out of range error on
the line:

X = SortArray((L+r)/2,col)

I'm getting ready to try creating a temporary array that will move my
array to

tempaRay(0,1) = aRay(0)
etc. in hopes that that will work...

Am I correct in my assumption?

2)

I saw in some old posts a routine called QSort by David Braden.
Do you have any knowledge of the difference from your routine and the
one included in your download in terms of speed sorting large arrays?
 
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
Has anyone used arrayfunctions from Alan Beban? SteveT Excel Worksheet Functions 3 February 26th 07 07:52 AM
VlookupS-Alan Beban Deeds Excel Worksheet Functions 4 December 20th 05 12:03 AM
Array Functions from Alan Beban Josh O. Excel Worksheet Functions 13 February 5th 05 12:54 AM
ResizeArray for Alan Question Marston Excel Programming 1 August 25th 04 07:29 PM
recursion depth, 'Out of stack space' in Quicksort marcel Excel Programming 0 April 21st 04 09:11 PM


All times are GMT +1. The time now is 09:34 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"