#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default sorting

Hi all,
does anyone know where I can find a fast sorting algorithm?
Thanks
Mathias
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default sorting

Hi
why no do a Google search for this phrase :-)
one (VB related):
http://www.vb-helper.com/tut1.htm

--
Regards
Frank Kabel
Frankfurt, Germany


Mathias wrote:
Hi all,
does anyone know where I can find a fast sorting algorithm?
Thanks
Mathias

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 49
Default sorting

Hi,

Do a search for Quicksort Algorithm which is fast, but has its limitations
that you cannot pass an already sorted list to it again. For an already
sorted list, use Bubble sort algorithm which is relatively slower but will
inform you that list is already sorted.

I hope this helps!

Rgds,

Eijaz
============================
"Mathias" wrote in message
...
Hi all,
does anyone know where I can find a fast sorting algorithm?
Thanks
Mathias



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 134
Default sorting

The algorithm you choose depends a lot on the number of
records you need to sort. It you have a few hundered to
several thousand reocrds, something simple like a bubble
sort will be quick enough. I doubt you would even notice
the difference with that number of records using the
Quicksort or another method. If you have a huge number of
records the Quicksort method is a good choice and the
Heapsort method is also good. Both of these are fairly
complicated to code but are do-able and perform well with
a large number of records.

It would be impossible for me to explain to you in this
forum the Quicksort or Heapsort methods, so I would
suggest doing a Web search. I am certain you will find
something that explains both of these methods.

Before choosing a method, I would consider the number of
records your sorting. You might even try a bubble sort
first because it is simple to code, then if that does not
perform like you want it, try one of these other methods.

Hope that helps!

Kevin
-----Original Message-----
Hi,

Do a search for Quicksort Algorithm which is fast, but

has its limitations
that you cannot pass an already sorted list to it again.

For an already
sorted list, use Bubble sort algorithm which is

relatively slower but will
inform you that list is already sorted.

I hope this helps!

Rgds,

Eijaz
============================
"Mathias" wrote in

message
...
Hi all,
does anyone know where I can find a fast sorting

algorithm?
Thanks
Mathias



.

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 49
Default sorting

Hi,

Incase you need the code for Quicksort ,please mail me & i'll send you the
code.

Rgds,

Eijaz


"Mathias" wrote in message
...
Hi all,
does anyone know where I can find a fast sorting algorithm?
Thanks
Mathias



Reply
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
Sorting Values Without Sorting Formulas SBX Excel Discussion (Misc queries) 2 April 12th 09 11:17 PM
Automatic sorting (giving max and min) based on custom sorting lis Joe Lewis[_2_] Excel Worksheet Functions 4 November 23rd 08 05:12 AM
Sorting VLookup vs Sorting SumProduct Lauren Excel Discussion (Misc queries) 1 August 21st 07 12:19 AM
Sorting: Sorting by the First Character dzuy Excel Discussion (Misc queries) 2 June 22nd 06 08:27 PM
Sorting ListBox results or transposing ListBox values to other cells for sorting Rob[_8_] Excel Programming 1 July 9th 03 04:35 AM


All times are GMT +1. The time now is 04:26 AM.

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

About Us

"It's about Microsoft Excel"