OK, so in my example, I've put the 'Bad Customers' on the second worksheet. When you apply the filter, you'll see there are only 2 that are 'Good Customers'.
Right now, BCE Inc is FALSE because they're not on the Bad Customers list. But say I wanted to add BCE Inc to the named list of Bad Customers. I would need to make sure that any data that comes in with BCE Inc (or any variation that contains those letters, like BCE, Inc., BCE Incorporated etc) would also be labeled as TRUE or Bad. Is that possible?
Bookmarks