Use the “Intersect lists” tool
Last updated: June 9, 2025
What it is: The Intersect lists tool is a tool that returns a list of items common to both input lists—only the elements that appear in both are included in the result.
What it’s for: Use this to find overlap between two data sets, such as identifying stocks that meet two different sets of criteria.
Example:"Show me which stocks appear in both my watchlist and the recommended list."
Key features:
Performs a logical AND operation
Only includes items found in both lists
Useful for narrowing down to items that meet multiple conditions