Sorting

[Guest]

Hello people
I have a spreadsheet which has the following format

Color Weight Code otherdata
33 44 55 A
B
C
Color Weight Code otherdata
22 33 44 D
E
F
I am trying to sort the "otherdata" catagory by either Color, Weight or Code.
I think the excel's function can't do this kind of sort and I am thinking about creating a userform with drop down box for letting users to choose which column they want to sort by.
However, I am not sure how to start(eg. how do you attach "otherdata" catagory with its specific Color Weight and Code then sort)???
Please help me out

Thank you in advance

 

[Anne Troy]

Your data is not Excel-friendly. I doubt you could possibly find a way to do this.

 

[Guest]

Oh no, even the macro can't do it?

 

[Guest]

Could someone please help me
Is this kind of sorting can be done in any way?

 

[Mark W.]

On 2002-03-07 07:25, Anonymous wrote:
Could someone please help me
Is this kind of sorting can be done in any way?

Eliminate your redundant headers and your problem is solved. If necessary you can add them back afterwards.
This message was edited by Mark W. on 2002-03-07 08:34

 

[Guest]

if I have many headers like
data1 data2 data3
11 33 33


data1 data2 data3
11 33 44
is there an easy way to delete those headers at once?

 

[Mark W.]

On 2002-03-07 08:36, Anonymous wrote:
if I have many headers like
data1 data2 data3
11 33 33


data1 data2 data3
11 33 44
is there an easy way to delete those headers at once?

Yeah, an easy way to delete, but not one to reinstate them after the sort. All you need to do to identify your headers is...

=ISTEXT(cell)

...where "cell" is a cell reference to the cell in the 1st column. If this formula returns TRUE that row is a header.

 

[Guest]

Right now, I have many headers in the format:

Data1 Data2 DAta3
11 22 33


Data1 Data2 Data3
22 33 44
...
...
I tried =istext(Data1) on both headers, and they all return True
So, how can I delete the headers after the first one?
Thanks

 

[Guest]

Hi Mark
After I did the number fill in and change the duplicated number to white colour, and press sort button. Some of the numbers, although the numbers are correct, they appear white where they should not be
why is it doing that?
Thanks