Lookup Strings in cell and return max and min values for each

[Panda]

Hi There,

I have a spreadsheet containing two worksheets Sheet 1 contains a list of part numbers and the processes that they have gone through and the total number of days it took.

On sheet 2 I have another table listing the same processes that some of the parts listed on sheet 1 have gone through. How do I search the table in sheet 1 for the processes listed in sheet 2 and return the maximum and minimum days that a process took?

I have tried to nest a =Vlookup with the max function but with no sucess can anybody help?

I have attached the spreadsheet but below is an example of what I have;

Sheet 1

Part Number Process Days Taken
abc123 Process 1 10
abc124 Process 2 30
abc125 Process 3 24
abc126 Process 4 5
abc127 Process 5 6
abc128 Process 1 98
abc129 Process 2 1
abc130 Process 3 15
abc131 Process 4 2
abc132 Process 5 54
abc133 Process 1 2
abc134 Process 2 67
abc135 Process 3 24
abc136 Process 4 56
abc137 Process 5 45


Sheet 2

Process Max Min
Process 1 ? ?
Process 2 ? ?
Process 3 ? ?
Process 4 ? ?
Process 5 ? ?



Thanks

Phil

[macropod]

Hi Phil,

See attached.