BruceRobertson

FilterValues Function Improvements

Discussion created by BruceRobertson on Sep 28, 2012
Latest reply on Feb 5, 2015 by CarlSchwarz

The Filtervalues function is extremely useful but has a frustrating limitation.

 

Currently it only allow you to return all values in List A that exist in List B.

 

We need at least, the opposite: All values in Lisit A that are NOT in List B.

 

Simple example:

 

A list of CustomerID values for a region.

A list of CustomerID value who meet some criteria.

For example: were recently sent promotional material.

 

Which customers in List A have NOT received this mailing?

 

A few people (including me) have addressed this with custom functions but the functions are inefficient as compared to a native feature.

Outcomes