Claymationator
Well-known Member
- Joined
- Sep 26, 2006
- Messages
- 705
I have a set of data ranging from A5:BY76 (below is a sample of the table). Column A contains a segment name and row 5 contains the location name. The data within the table is a household count showing how many households fall into each segment for each location.
What I want to do is create a formula where I look at the data range for a specific location, and then return the location name that most closely matches. Matching would be done comparing the household counts in each location.
Excel 2010 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
5 | Segment Name | 001 St. George | 002 Provo | 003 Fort Union | 004 Skyline | 005 Draper | ||
6 | A01: American Royalty | 4 | 113 | 370 | 527 | 554 | ||
7 | A02: Platinum Prosperity | 214 | 850 | 1940 | 1548 | 1248 | ||
8 | A03: Kids and Cabernet | 82 | 1109 | 1423 | 628 | 3402 | ||
9 | A04: Picture Perfect Families | 768 | 2222 | 3012 | 2658 | 1794 | ||
10 | A05: Couples with Clout | 248 | 923 | 1539 | 899 | 2498 | ||
11 | A06: Jet Set Urbanites | 2 | 24 | 2 | 22 | 8 | ||
12 | B07: Generational Soup | 62 | 3262 | 3371 | 884 | 8274 | ||
AdHocPIVOT |
What I want to do is create a formula where I look at the data range for a specific location, and then return the location name that most closely matches. Matching would be done comparing the household counts in each location.