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