- In short
- Counts how many times each value appears in the selected column and writes the result into a new column on the right. The original column is not changed. A new count column. Your table stays untouched, and Undo Last stands by if you change your mind.
What it is for
Add Duplicate Count is used to add a column with each value's occurrence count.
When to use it
It earns its place whenever you have to compute repeat counts to filter/sort.
Example scenarios
- Compute repeat counts to filter/sort.
What it needs
A single column and an options dialog. Supported data types: text, number, date (by selection).
How to use it
- Select the range to compare.
- Run Add Duplicate Count from the Compare & Check group on the XLMind Plus tab.
- Pick the settings you need in the window that opens.
- Confirm; a new count column.
What it produces
A new count column.
Effect on your data and undo
Add Duplicate Count does not change your source data; the result is added as a separate item. One click on Undo Last brings everything back.
How it differs from similar tools
No helper formulas are needed; the source area is read but never written, and the output is produced on its own.
Good to know
No special preconditions.
Limitations
No special preconditions.
Frequently asked questions
- Where is the output written?
- A new count column.
- What happens to invalid or unexpected values?
- Codes not parsed.
- Does the result stay linked to the source?
- What you get is static: it will not follow later edits, so rerun the tool once the data moves on.
- Any known limits?
- No special preconditions.
Works well with
- Before you start, consider Highlight Unique Values
- Afterwards, try Extract Unique List
- Often used alongside this tool: Compare Two Lists
Your Excel data is processed on your own computer and is not shared with AI services. The limited data needed for licensing, sales and support is held on our infrastructure in Türkiye.