How is this different from Common List Item Finder?

Common List Item Finder returns the intersection (items in both lists). Distinct List Item Finder returns the opposite: the symmetric difference, items in exactly one of the two lists, excluding anything shared by both.

How is this different from List Subtractor?

List Subtractor is one-directional: List A minus List B only, preserving List A's duplicates. Distinct List Item Finder is symmetric and deduped: it includes both List A's exclusives AND List B's exclusives in one combined, deduped result.

What happens if both lists contain exactly the same set of values?

You'll get an error explaining the lists are identical sets, since the symmetric difference is empty by definition in that case.

Distinct List Item Finder - Symmetric Difference of Two Lists

Overview

Introduction

Sometimes what you need isn't the overlap between two lists, but everything that ISN'T shared, the values unique to just one side or the other.

Distinct List Item Finder computes exactly that symmetric difference, combining both lists' exclusives into one deduped result.

What Is Distinct List Item Finder?

A symmetric-difference tool: it identifies List A's values that aren't in List B, and List B's values that aren't in List A, then combines both groups.

Unlike List Subtractor's one-directional A-minus-B, this tool treats both lists equally, capturing exclusives from either side.

How Distinct List Item Finder Works

Both inputs are split into items using the shared selected separator, then each is deduped into a set of distinct values.

List A's values not found in List B's set form the first part of the output; List B's values not found in List A's set are appended after.

When To Use Distinct List Item Finder

Use it to see everything that differs between two lists, regardless of which side it came from, in one combined view.

It's useful for spotting drift between two datasets that are supposed to match but may have diverged in either direction.

Often used alongside Common List Item Finder, List Comparer and List Subtractor.

Features

Advantages

Captures exclusives from both directions in a single deduped result, unlike a one-directional subtraction.
Clear error messaging when the two lists are identical, instead of a silently empty result.

Limitations

Doesn't distinguish which items came from List A versus List B in the combined output beyond their ordering (A's exclusives first, then B's).
Comparison is exact and case-sensitive with no trimming applied.

Examples

Finding items unique to either list

Input

List A: a, b, c
List B: b, c, d

Output

a, d

"a" is exclusive to List A and "d" is exclusive to List B; "b" and "c", shared by both, are excluded.

Identical lists

Input

List A: a, b
List B: b, a

Output

(error: identical sets)

Both lists contain exactly the same set of values (order doesn't matter for set comparison), so the symmetric difference is empty.

Best Practices & Notes

Best Practices

Use List Comparer instead if you need only-A and only-B kept as clearly separate sections rather than combined.
Follow up with List Item Finder on the original lists if you need to know each result item's exact position.

Developer Notes

Computes `onlyInA` and `onlyInB` independently via `Array.filter()` against `Set.has()` checks on the opposite list, then concatenates the two arrays (`[...onlyInA, ...onlyInB]`) to form the combined symmetric-difference result.

Distinct List Item Finder Use Cases

Spotting drift between two datasets that should theoretically match
Finding every value that differs between two versions of an exported list, from either direction
Auditing two independently maintained lists for accidental divergence

Common Mistakes

Expecting the output to indicate which list each item came from; only its position (A's exclusives first) hints at that.
Confusing this with List Comparer's only-A/only-B sections, which are kept explicitly separate rather than combined.

Tips

If you need to know exactly which list each distinct item came from, use List Comparer's separate only-A/only-B sections instead.
Run Common List Item Finder alongside this tool to see the full picture: what's shared plus what's exclusive.

Distinct List Item Finder