Question posted 2012 · +8 upvotes
I have a column of text values with repeated values. I want to create a new column of unique values (no repeats) and a column with the frequency of each of those values.
What’s the easiest way to do that? Efficiency isn’t much of a concern as it’s under 10,000 rows.
Accepted answer +15 upvotes
For the sake of an answer rather than comments, copy column (say A) to B (say) and for B only Data > Data Tools â Remove Duplicates then in C2 enter:
=COUNTIF(A:A,B2)
and copy down as required
OR (preferred option)
use a PivotTable as @Tim:
Top excel Q&A (6)
- Shortcut to Apply a Formula to an Entire Column in Excel +335 (2011)
- How should I escape commas and speech marks in CSV files so they work in Excel? +136 (2012)
- Convert xlsx to csv in linux command line +96 (2012)
- How to create a link inside a cell using EPPlus +50 (2011)
- IF statement: how to leave cell blank if condition is false ("" does not work) +44 (2013)
- T-SQL: Export to new Excel file +44 (2012)
excel solutions on this site
— top 25%.