This is the end, beautiful friend.
View Single Post
12-18-2012, 02:33 PM
Join Date: Dec 2007
Location: New York, NY
Originally Posted by
For any Excel junkies: what's the easiest way to count the number of same entries in a column? For example, if I have spreadsheet with contact information that has columns like Name, City, State, etc. and I want to know how many people are in each city, what's the easiest way to get that? I'd basically just need it to come back with a number for how many times it finds each city in the column.
A pivot table like JB suggested would work; and if you're looking for a formula for a cell count, it would be something like IIRC:
...where A represents column and # equals row; obviously, edit location and cells to your document.
EDIT: crap, LDS beat me to it.
View Public Profile
Find More Posts by Woodhouse