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 Data Type question / Sort

Hi

I'm trying to prep some values for a multi-column sort in an array.
The array contains something like 300,000 by 10 values
I've seen quick sort routines that can sort on a single value, but not
perform sorts within the initial sort.

My idea was to concatenate all my values into a single value and then
sort on it. The problem I'm facing is that my numbers would have to be
on the order of ~10E+18-1 long

The way the routine works is it looks at the numbers in each column
whose length is fixed and never has a situation where there are
leading zeros to cause problems.

Col 1 Col 2 Col 3 Col 4 Col 5 Col 6
Row x: aaa bbb cc ddddd e fff

I only need to arrange based on these 6 columns not the entire 10 in
the array

My problem is when I create a number like aaabbbccdddddefff it appears
to have
problems with the "efff" portion. I checked each individual component
(which I'm multiplying by some 1nnnn where n is some number of zeros -
and they all work fine, its just once I tried to add things. Its like
it drops values off.
I have the variables defined as Double which I thought would work.

Any thoughts?
 
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
question about the data type in excel fairyvoice Excel Discussion (Misc queries) 1 June 17th 09 02:48 PM
Data Sort Question bankerlady Excel Discussion (Misc queries) 2 February 13th 07 07:34 PM
Data Sort 2 part question Roman Excel Discussion (Misc queries) 0 March 3rd 06 08:00 PM
a sort of GROUP BY data extraction question... jc Excel Worksheet Functions 2 January 9th 06 07:49 PM
Newbie Question: Data/Sort [email protected] New Users to Excel 1 February 21st 05 11:37 PM


All times are GMT +1. The time now is 10:15 PM.

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"