View Single Post
Old
12-18-2012, 02:33 PM
  #813
Woodhouse
Registered User
 
Woodhouse's Avatar
 
Join Date: Dec 2007
Location: New York, NY
Posts: 8,476
vCash: 50
Quote:
Originally Posted by Myllz View Post
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:
Quote:
=COUNTIF(A2:A100,"Buffalo")
...where A represents column and # equals row; obviously, edit location and cells to your document.

EDIT: crap, LDS beat me to it.

Woodhouse is offline