I've been hunting around google and forums trying to figure this out out using a formula vs VBA. I'm using google sheets currently for this.
ColA - Account ID / ColB - Customer Name / ColC Customer sub accounts (ranges from 1-15 separate names)
Another sheet contains all the customer record...