In the site column, can the sites occur more than once per type of
vehicle,
meaning if there is one MSN Autos for cars and one for trucks, that
would
total 2 thus return yes?
Yes sites can occur more then once.
Example
Type | Site | Match
cars | Automart.com | N
cars | MSN Autos | Y
cars | ford.com | Y
trucks| MSN Autos | Y
food | kraft.com | N
trucks | ford.com | Y
cars | ford.com | Y
cars | ford.com | Y
cars | ford.com | Y
cars | Automart.com | N
Also Sites should be Y even if for types that are not cars and truck if
the above condition is true.
food | kraft.com | N
food | ford.com | Y
food | ford.com | Y
food | ford.com | Y
food | ford.com | Y
food | Automart.com | N
Thanks for the help but it is still not what I need.
--
exceluser2
------------------------------------------------------------------------
exceluser2's Profile:
http://www.excelforum.com/member.php...o&userid=31338
View this thread:
http://www.excelforum.com/showthread...hreadid=510203