Sorting data using multiple conditions

Otispunkmeyer

New Member
Joined
Oct 2, 2006
Messages
8
I have alot of data from a plate levelling machine

plate name, width, lenght, gauge, yield data, roll mode, overstretch and strategy used

there are 5 worksheets in this book 1 = levelled plates in 1 pass, 2 = levelled plates in 2 passes etc

firstly i would like to know how to sort the data with regards to plate dimensions

ie.... i need an operation/program that will go through the width and length columns and group all like plates together (so 4000x2000 plates get grouped and highlighted in yellow, the 10000x3000 get grouped and highlighted in green)

is this easy to do? i have limited knowledge of excel and VB but i tend to learn fast.
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

onlyadrafter

Well-known Member
Joined
Aug 19, 2003
Messages
5,703
Platform
  1. Windows
Hello,

Why can't you do a manual sort? first by width column, then by length column?
 

Otispunkmeyer

New Member
Joined
Oct 2, 2006
Messages
8
Hello,

Why can't you do a manual sort? first by width column, then by length column?

i tried that, but it seems that its not doing it right

i sorted the first sheet by hand since most plates were 4000x1900 and i highlighted them

when i tried to sort them (to test it out) it seems to be breaking up the row.

so i have plate number, width, length, gauge all in the right place, but then the strategy column has become detached and is now stuck on some other plate

plus i need to sort by both width and lenght, so if i sort by column B and then by column C it still has things in a muddle

i need to physically extract certain plate sizes like 4000x1900 take them out the list and drop them in a new sheet.
 

onlyadrafter

Well-known Member
Joined
Aug 19, 2003
Messages
5,703
Platform
  1. Windows
Hello,

Try FILTER or ADVANCED FILTER to move to a new sheet.
 

Otispunkmeyer

New Member
Joined
Oct 2, 2006
Messages
8
lol really not sure how to use this

List range = is the whole list right?

Criteria range? what is that?


why cant they just make it so you can highlight your data and just ask it to find the numbers 4000 and 1900 in their respective columns

maybe they have, im jus too inept to use it :rolleyes: :confused:
 

Otispunkmeyer

New Member
Joined
Oct 2, 2006
Messages
8
hahaha!

think i got it, AutoFilter puts little drop down things on top of the columns...ill just do it like this and physically move them, should be ok
 

Forum statistics

Threads
1,136,926
Messages
5,678,606
Members
419,775
Latest member
joh93

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
Top