Finding the maximum number using an if criteria

Matt --

You have a Date Returned column, but that would be not enough to compute a min and/or max duration. What do you have exactly in other columns?

Aladin

==========

Aladin,
There is also a column labled turnaround which lists, in workdays, the number of days a part has been out.
Thanks,

Matt

Matt --

Instead of bothering you with further questions, I'll cook up in what follows a situation similar to yours (I hope).

Lets say that A1:C6 houses the sample data:

{"Part","Vendor","Turnaround";
"p1","v1",7;
"p2","v1",8;
"p1","v2",5;
"p3","v1",6;
"p1","v1",5}

In F1 enter: p1 [ a part of interest ]
In H1 enter: p2 [ likewise a part of interest ]
In F2 enter: min
In G2 enter: max
In H2 enter: min
In I2 enter: max

In E3 enter: v1
In E4 enter: v2

Notice that I've put parts across in row 1 and vendors (a list of unique items) in E from E3 on.

In F3 array-enter: =MIN(IF(($A$2:$A$6=F$1)*($B$2:$B$6=$E3),($C$2:$C$6)))
In G3 array-enter: =MAX(($A$2:$A$6=F$1)*($B$2:$B$6=$E3)*($C$2:$C$6))

You need to hit control+shift+enter at the same time, insted of just enter, to array-enter a formula.

Now select F3:G3 and drag across as far as needed then down.

The following is what you see in the results area:

{"","p1","","p2","";"","min","max","min","max";"v1",5,7,8,8;"v2",5,5,0,0}

that is, in E1:I4.

Hope this is what you want.

=========== ,

Yes, Thank you very very much. -- Instead of bothering you with further questions, I'll cook up in what follows a situation similar to yours (I hope). Lets say that A1:C6 houses the sample data: {"Part","Vendor","Turnaround";