Where did the traveling salesman get the flu?

[Tommy2Tables]

I want to find what person is most likely to have infected my salesman.
I have two tables, one of sick salesmen and their customers and the well salesmen and their customers.
The customers overlap.
I want to find the most common customers that might have made them sick by subtracting out the customers that the sick and well both saw.

I can find out which are the most common customers between the salesmen with an Advanced Filter and COUNTIF, like this procedure 1) Select the entire column B
2) Open the Data...Filter...Advanced Filter menu item
3) Check the boxes for "Unique records only" and "Filter the list, in place"
4) Click OK. Excel will now collapse the list into just the unique records. All other rows are hidden.
5) Enter this formula in cell C2: =COUNTIF($B$2:$F$50,B2)
6) Copy this formula down to the end of your list
then descending sort This procedure is described here:
Counting frequency and ranking

But I also want it to remove the customers in common with the well salesmen who did not get them sick.
[TABLE="width: 232"]
<colgroup><col span="2"></colgroup><tbody>[TR]
[TD]SICK SALESMEN[/TD]
[TD]CUSTOMERS[/TD]
[/TR]
[TR]
[TD]Roger Oneil[/TD]
[TD]Ines Lobaugh[/TD]
[/TR]
[TR]
[TD]Roger Oneil[/TD]
[TD]Ramona Borges[/TD]
[/TR]
[TR]
[TD]Roger Oneil[/TD]
[TD]James Wheat[/TD]
[/TR]
[TR]
[TD]Roger Oneil[/TD]
[TD]Joey Flory[/TD]
[/TR]
[TR]
[TD]Roger Oneil[/TD]
[TD]Ross Beckemeyer[/TD]
[/TR]
[TR]
[TD]Roger Oneil[/TD]
[TD]Ines Lobaugh[/TD]
[/TR]
[TR]
[TD]Pedro Conway[/TD]
[TD]Ines Lobaugh[/TD]
[/TR]
[TR]
[TD]Pedro Conway[/TD]
[TD]Brian Matias[/TD]
[/TR]
[TR]
[TD]Pedro Conway[/TD]
[TD]Twila Leimbach[/TD]
[/TR]
[TR]
[TD]Pedro Conway[/TD]
[TD]Andy Kysar[/TD]
[/TR]
[TR]
[TD]Pedro Conway[/TD]
[TD]Ramona Borges[/TD]
[/TR]
[TR]
[TD]Pedro Conway[/TD]
[TD]Belinda Roby[/TD]
[/TR]
[TR]
[TD]Eric McKinnis[/TD]
[TD]Ines Lobaugh[/TD]
[/TR]
[TR]
[TD]Eric McKinnis[/TD]
[TD]Ramona Borges[/TD]
[/TR]
[TR]
[TD]Eric McKinnis[/TD]
[TD]Michael Amato[/TD]
[/TR]
[TR]
[TD]Eric McKinnis
[/TD]
[TD]Ines Lobaugh[/TD]
[/TR]
[TR]
[TD]Eric McKinnis[/TD]
[TD]Belinda Roby[/TD]
[/TR]
[TR]
[TD]Gwen Andrew[/TD]
[TD]Ines Lobaugh[/TD]
[/TR]
[TR]
[TD]Gwen Andrew[/TD]
[TD]Ramona Borges[/TD]
[/TR]
[TR]
[TD]Gwen Andrew[/TD]
[TD]Bridgett Althaus[/TD]
[/TR]
[TR]
[TD]Gwen Andrew[/TD]
[TD]Belinda Roby[/TD]
[/TR]
[TR]
[TD]Lawrence Curran[/TD]
[TD]Ines Lobaugh[/TD]
[/TR]
[TR]
[TD]Lawrence Curran[/TD]
[TD]Ramona Borges[/TD]
[/TR]
[TR]
[TD]Lawrence Curran[/TD]
[TD]Bridgett Althaus[/TD]
[/TR]
[TR]
[TD]Lawrence Curran[/TD]
[TD]Concetta Tasso[/TD]
[/TR]
[TR]
[TD]Lawrence Curran[/TD]
[TD]Belinda Roby[/TD]
[/TR]
[TR]
[TD]Howard Acker[/TD]
[TD]Ines Lobaugh[/TD]
[/TR]
[TR]
[TD]Howard Acker[/TD]
[TD]Ramona Borges[/TD]
[/TR]
[TR]
[TD]Howard Acker[/TD]
[TD]Stuart Phaup[/TD]
[/TR]
[TR]
[TD]Howard Acker[/TD]
[TD]Willard Bolan[/TD]
[/TR]
[TR]
[TD]Howard Acker[/TD]
[TD]John Gottard[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WELL SALESMEN
[/TD]
[TD]CUSTOMERS[/TD]
[/TR]
[TR]
[TD]Mara Maltz[/TD]
[TD]Ines Lobaugh[/TD]
[/TR]
[TR]
[TD]Mara Maltz[/TD]
[TD]Bridgett Althaus[/TD]
[/TR]
[TR]
[TD]Mara Maltz[/TD]
[TD]Lillie Carpenter[/TD]
[/TR]
[TR]
[TD]Mara Maltz[/TD]
[TD]Cora Mcnamara[/TD]
[/TR]
[TR]
[TD]Jimmy Lowder[/TD]
[TD]Ines Lobaugh[/TD]
[/TR]
[TR]
[TD]Jimmy Lowder[/TD]
[TD]Vivian Bogart[/TD]
[/TR]
[TR]
[TD]Jimmy Lowder[/TD]
[TD]Victoria Madison

[/TD]
[/TR]
</tbody>[/TABLE]
In this example, everyone well and sick, visits Ines Lobaugh, so even though she is very common, she should be subtracted from the results.
Thank you.
Tommy2Tables

 

[shawnhet]

There are probably many different ways to do this but here's mine.

I put your sick persons table in A2:A32 and your well salesmen table in G2:H2

Then in C2 I posted and copied down

=if(IF(ISERROR(VLOOKUP(B2,$H$2:$H$8,1,FALSE)),1,0)*COUNTIF($B$2:$B$32,B2)=6,B2,"")
The six is for the fact that there are six sick salesmen.

Cheers,

 

[Marcelo Branco]

Hi and welcome to MrExcel forum

To find what person is most likely to have infected the salesmen maybe something like this

Assuming table1 in A1:B32 and table2 in D1:E8

A B C D E F G H I J
[TABLE="class: grid, width: 800"]
<tbody>[TR]
[TD="width: 111, bgcolor: transparent"]SICK SALESMEN
[/TD]
[TD="width: 116, bgcolor: transparent"]CUSTOMERS
[/TD]
[TD="width: 69, bgcolor: transparent"][/TD]
[TD="width: 108, bgcolor: transparent"]WELL SALESMEN
[/TD]
[TD="width: 112, bgcolor: transparent"]CUSTOMERS
[/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 103, bgcolor: transparent"]CUSTOMERS
[/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"]Criteria
[/TD]
[TD="width: 64, bgcolor: transparent"]Max
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Roger Oneil
[/TD]
[TD="bgcolor: transparent"]Ines Lobaugh
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Mara Maltz
[/TD]
[TD="bgcolor: transparent"]Ines Lobaugh
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Ramona Borges
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: center"]FALSO
[/TD]
[TD="bgcolor: transparent, align: right"]6
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Roger Oneil
[/TD]
[TD="bgcolor: transparent"]Ramona Borges
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Mara Maltz
[/TD]
[TD="bgcolor: transparent"]Bridgett Althaus
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Roger Oneil
[/TD]
[TD="bgcolor: transparent"]James Wheat
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Mara Maltz
[/TD]
[TD="bgcolor: transparent"]Lillie Carpenter
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Roger Oneil
[/TD]
[TD="bgcolor: transparent"]Joey Flory
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Mara Maltz
[/TD]
[TD="bgcolor: transparent"]Cora Mcnamara
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Roger Oneil
[/TD]
[TD="bgcolor: transparent"]Ross Beckemeyer
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Jimmy Lowder
[/TD]
[TD="bgcolor: transparent"]Ines Lobaugh
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Roger Oneil
[/TD]
[TD="bgcolor: transparent"]Ines Lobaugh
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Jimmy Lowder
[/TD]
[TD="bgcolor: transparent"]Vivian Bogart
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Pedro Conway
[/TD]
[TD="bgcolor: transparent"]Ines Lobaugh
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Jimmy Lowder
[/TD]
[TD="bgcolor: transparent"]Victoria Madison
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Pedro Conway
[/TD]
[TD="bgcolor: transparent"]Brian Matias
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Pedro Conway
[/TD]
[TD="bgcolor: transparent"]Twila Leimbach
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Pedro Conway
[/TD]
[TD="bgcolor: transparent"]Andy Kysar
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Pedro Conway
[/TD]
[TD="bgcolor: transparent"]Ramona Borges
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Pedro Conway
[/TD]
[TD="bgcolor: transparent"]Belinda Roby
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Eric McKinnis
[/TD]
[TD="bgcolor: transparent"]Ines Lobaugh
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Eric McKinnis
[/TD]
[TD="bgcolor: transparent"]Ramona Borges
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Eric McKinnis
[/TD]
[TD="bgcolor: transparent"]Michael Amato
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Eric McKinnis
[/TD]
[TD="bgcolor: transparent"]Ines Lobaugh
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Eric McKinnis
[/TD]
[TD="bgcolor: transparent"]Belinda Roby
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Gwen Andrew
[/TD]
[TD="bgcolor: transparent"]Ines Lobaugh
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Gwen Andrew
[/TD]
[TD="bgcolor: transparent"]Ramona Borges
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Gwen Andrew
[/TD]
[TD="bgcolor: transparent"]Bridgett Althaus
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Gwen Andrew
[/TD]
[TD="bgcolor: transparent"]Belinda Roby
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Lawrence Curran
[/TD]
[TD="bgcolor: transparent"]Ines Lobaugh
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Lawrence Curran
[/TD]
[TD="bgcolor: transparent"]Ramona Borges
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Lawrence Curran
[/TD]
[TD="bgcolor: transparent"]Bridgett Althaus
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Lawrence Curran
[/TD]
[TD="bgcolor: transparent"]Concetta Tasso
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Lawrence Curran
[/TD]
[TD="bgcolor: transparent"]Belinda Roby
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Howard Acker
[/TD]
[TD="bgcolor: transparent"]Ines Lobaugh
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Howard Acker
[/TD]
[TD="bgcolor: transparent"]Ramona Borges
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Howard Acker
[/TD]
[TD="bgcolor: transparent"]Stuart Phaup
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Howard Acker
[/TD]
[TD="bgcolor: transparent"]Willard Bolan
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Howard Acker
[/TD]
[TD="bgcolor: transparent"]John Gottard
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]

Enter the Headers CUSTOMERS, Criteria and Max in respectively G1, I1, J1

In J2 enter this array formula
=MAX(IF(ISNA(MATCH($B$2:B$32,E$2:E$8,0)),COUNTIF($B$2:$B$32,$B$2:$B$32)))

must be confirmed with Ctrl+Shift+Enter simultaneously
(hold down both Ctrl and Shift keys and hit Enter)

in I2 (under Criteria) enter this formula
=AND(ISNA(MATCH(B2,$E$2:$E$8,0)),COUNTIF($B$2:$B$32,B2)=$J$2)

SElect A1:B32 and go to Data> Advanced Filter

pick Copy to another location
List range: A1:B32
Criteria Range: I1:I2
Copy to: G1
check Unique records only

Ok

M.

 

[Tommy2Tables]

I did not respond because this solution and the other one blew my mind. I am going to try to take on smaller chunks of this at one time. Thank you. T2T