Find 02)


Builds a “Unique List” from the selected values.

This can be useful in a variety of situations:

1. Build a list for use with a “SUMIF” function.
2. Create a formula that returns a TRUE or FALSE, if you expect all “TRUES” then use this to quickly ensure that only “TRUES” exist.
3. In fact you can look for the absence of anything, if it doesn’t return in the list then it isn’t there.
4. Build a unique list for use in a SQL “Where” clause.

 

Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc