Sorting

G

Guest

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
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
Your data is not Excel-friendly. I doubt you could possibly find a way to do this.
 
Upvote 0
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
 
Upvote 0
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?
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,532
Messages
6,114,177
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top