Use Domenic's formula but take off the SUM part

=SUMPRODUCT(--(A2:A7=G2),--(MATCH(C2:C7&"#"&D2:D7,C2:C7&"#"&D2:D7,0)=ROW(C2:C 7)-ROW(C2)+1))

will return 2 using your posted example data

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon




"JR573PUTT" wrote
in message ...

Thanks, there has to be a way to say if column d and column e repeat,
count column f only once, seems simple, probably is a simple formula,
that is why it is so difficult!


--
JR573PUTT
------------------------------------------------------------------------
JR573PUTT's Profile:
http://www.excelforum.com/member.php...o&userid=31587
View this thread: http://www.excelforum.com/showthread...hreadid=513715