Hi everyone,
Got a big puzzle/challenge for you. I’m framing it this way because I know it’s a bit of a doozy, even if on its surface it might not be. I have intermediate-level Excel abilities; I’ve used it for a lot of math, have done pivot tables, 15 years ago I even used macros (?) to make somewhat of a point-of-sale system where cashiers could click buttons that would essentially total up ticket purchases and add them to running totals. So I’m willing to get a bit into the weeds, that said, I don’t have a strong command of what’s available. Right now I need help measuring overlap of email lists numerically (rather than highlighting specific or naming specific items that overlap).
Let’s say I have 10 lists, which I do. We’ll call them lists A through J.
I’d like to be able to look at each list and tally up how many people overlap. It’d essentially be one table for each list, that’d hypothetically read out as:
List A: 10,000 email addresses
38 people on 9 other lists
73 people on 8 other lists
125 people on 7 other lists
[so on and so forth until 1 other list]
List B: 8,000 email addresses
25 people on 9 other lists
and on and on until we have tables for each letter up through J.
One additional wrinkle is that it has to be such that the “other lists” can’t be specific. IE When I want to know how many people on list A are on “7 other lists”, there are endless combinations of what those seven other lists could be. I don’t want to just remove B and C, because that’s just one combination of 7. All lists (that aren’t A in this case) need to be cross-checked to create that tally.
Thank you for reading this far and for your time. I hope I’m making sense. Open to any ideas or clues!
Got a big puzzle/challenge for you. I’m framing it this way because I know it’s a bit of a doozy, even if on its surface it might not be. I have intermediate-level Excel abilities; I’ve used it for a lot of math, have done pivot tables, 15 years ago I even used macros (?) to make somewhat of a point-of-sale system where cashiers could click buttons that would essentially total up ticket purchases and add them to running totals. So I’m willing to get a bit into the weeds, that said, I don’t have a strong command of what’s available. Right now I need help measuring overlap of email lists numerically (rather than highlighting specific or naming specific items that overlap).
Let’s say I have 10 lists, which I do. We’ll call them lists A through J.
I’d like to be able to look at each list and tally up how many people overlap. It’d essentially be one table for each list, that’d hypothetically read out as:
List A: 10,000 email addresses
38 people on 9 other lists
73 people on 8 other lists
125 people on 7 other lists
[so on and so forth until 1 other list]
List B: 8,000 email addresses
25 people on 9 other lists
and on and on until we have tables for each letter up through J.
One additional wrinkle is that it has to be such that the “other lists” can’t be specific. IE When I want to know how many people on list A are on “7 other lists”, there are endless combinations of what those seven other lists could be. I don’t want to just remove B and C, because that’s just one combination of 7. All lists (that aren’t A in this case) need to be cross-checked to create that tally.
Thank you for reading this far and for your time. I hope I’m making sense. Open to any ideas or clues!
