I have a table with 3 columns, A= Name, B= City, C=Item. This table may have thousands of rows of data. I then have a second table that list each City and each Item for that city. In column H I need to return the Name that appears most often for that combination of City and Item. I this example for Modesto and Table, Joe appeared most often. Incase of a tie, Miami and Chair I need the name that appears first in the list, Bill.
Excel 2016 (Windows) 32 bit
Excel 2016 (Windows) 32 bit
A | B | C | D | E | F | G | H | |
---|---|---|---|---|---|---|---|---|
2 | Name | City | Item | City | Item | Name | ||
3 | Joe | Modesto | Table | Modesto | Table | Joe | ||
4 | Joe | Modesto | Table | Modesto | Chair | Joe | ||
5 | Joe | Modesto | Chair | Modesto | Lamp | Tom | ||
6 | Joe | Modesto | Chair | Miami | Table | Bill | ||
7 | Tom | Modesto | Table | Miami | Chair | Bill | ||
8 | Tom | Modesto | Chair | Miami | Lamp | Sally | ||
9 | Tom | Modesto | Lamp | |||||
10 | Tom | Modesto | Lamp | |||||
11 | Bill | Miami | Table | |||||
12 | Bill | Miami | Table | |||||
13 | Bill | Miami | Chair | |||||
14 | Bill | Miami | Chair | |||||
15 | Sally | Miami | Table | |||||
16 | Sally | Miami | Chair | |||||
17 | Sally | Miami | Chair | |||||
18 | Sally | Miami | Lamp |
Sheet: Sheet1 |