Data mining question

  • Thread starter Thread starter Flcnmech
  • Start date Start date
F

Flcnmech

I have a large amount of data that I have dumped into a worksheet. This data
is composed of data such as:

Assembly code AA0
sub code AA1 154.8
sub code AA2 1154.8
sub code AA3 54.8
Assembly code AB0
sub code AB1 2525.0
sub code AB2 25.0

What I would like to do is set up a data mine to find the low time for each
assembly from the subs and give me that low time as a result.

I hope that makes sense. Thank you in advance.
 
You may want to create a new column as (assuming your assembly codes
are consistent):
Assembly code AA0 AA
sub code AA1 154.8 AA
sub code AA2 1154.8 AA
sub code AA3 54.8 AA
Assembly code AB0
sub code AB1 2525.0 AB
sub code AB2 25.0 AB
Click to expand...

You can use some text functions to extract this, eg: D2=MID($B2,6,2)
or craft an if statements to update the code whenever 'Assembly' is in
the first col, eg: D2=if($A2="Assembly",$B2,$D1). The later case
requires your data to be sorted correctly.

Then use a pivot table using the new column as a Row descriptor and
the time col as your data field. Change the field type from Sum to
Min.
 
Okay, I think I follow you, but... the Assembly and their codes are not going
to be in the data table... So I think I should go for the first option...
I'll probably be back.

Thank you,
 
Back
Top