I have a column of several hundred text values, such as "a1" and "a2". I want to find out how many a1's are in that column, how many a2's, etc. How can I do this?
Thanks
I have a column of several hundred text values, such as "a1" and "a2". I want to find out how many a1's are in that column, how many a2's, etc. How can I do this?
Thanks
Try pivot tables:
http://peltiertech.com/Excel/Pivots/pivotstart.htm
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
HI
List Unique values* in col B (say B2 to B25) and insert the formula
C2=countif($A$2:$A$500,B2)
Drag the formula down
* You can use DATA > filter > advanced filter > Unique records only and copy to another location.
Ravi
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks