Panda
10-13-2010, 02:55 AM
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
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