Find Unique Values in Column
List the distinct values of one column of a pasted data set, in order.
What this page computes
Paste a data set and the page prints the distinct values of the column you name, in the order they first appear, with a count. The column number is 1-based and the width is taken from the first row.
Where it stops
A column number past the width of the first row is refused with the width, so a typo cannot quietly print one empty value. Values are trimmed for comparison and case is not folded; a header row is skipped when you say the first row is one.
Why the answer repeats
The distinct list is a Set built in this tab, so the same paste always prints the same values in the same order, and no column of data is uploaded.
Prints the distinct values of one column of a pasted data set, in first-appearance order, with a count and the data-row total. The column number must exist in the first row; a header row is skipped when declared.
How to use it
Paste the data, set the delimiter, column number and header flag, then press Run.
The arithmetic
Rows are split on the delimiter and the field at column − 1 is trimmed. A Set records what has been printed, so a repeated value is skipped while the order stays that of the paste.
What to Expect
Best for
- listing categories in an export
- counting distinct values in a column
What this tool keeps
- the distinct values and their count
Sample input
a,b / 1,x / 2,x / 3,y with column 2 and a header
Sample output
x y Unique values = 2 in column 2 of 3 data row(s).
Frequently asked questions
How do I use the find unique values page?
Paste the data, set the column number and options, then press Run.
Is anything uploaded?
No. The whole calculation runs in this tab with JavaScript: no request is made, no account is needed, nothing is stored, and the page keeps working offline once it has loaded.
What are its limits or bounds?
The column must be a whole number from 1 to the width of the first row, and the box must hold data. A column past the width must be refused with that width.
Build custom tools for your store
Join the SDK program to create useful ecommerce utilities for your store.