Find 02)

02) Builds Unique List of Values From Selected Cells

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