sorry - the count needs to be only for the car in question, as well as
the tire #.

=SMALL(IF(($D$3:$D$15=G3)*($A$3:$A$15="x1234"),$C$ 3:$C$15),COUNT(IF(($D$3:$D$15=G3)*($A$3:$A$15="x12 34"),$D$3:$D$15)))-SMALL(IF(($D$3:$D$15=G3)*($A$3:$A$15="x1234"),$C$3 :$C$15),COUNT(IF(($D$3:$D$15=G3)*($A$3:$A$15="x123 4"),$D$3:$D$15))-1)


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=474645