续订 - 有一个实例相同的产品和公司开始日期较早

Renewal - there is an instance of the same product and company with an earlier start date

=COUNTIFS(A$2:A$7,A2,B$2:B$7,B2,D$2:D$7,"<"&D2)>0

到产品 - 没有相同的产品和公司的开始日期较早，但还有一个其他产品的实例相同的公司
与较早的开始日期

New to product - there is no instance of the same product & company with an earlier start date, but there is an instance of another product & same company with an earlier start date

=AND(COUNTIFS(A$2:A$7,A2,B$2:B$7,B2,D$2:D$7,"<"&D2)=0,COUNTIFS(A$2:A$7,"<>"&A2,B$2:B$7,B2,D$2:D$7,"<"&D2)>0)

没有与之前开始日期相同的公司的实例

New to business - there is no instance of the same company with an earlier start date

=COUNTIFS($B$2:$B$7,B2,$D$2:$D$7,"<"&D2)=0