Solved

Count Number of Instances In A Column In Excel

Posted on 2014-11-20
4
141 Views
Last Modified: 2014-11-20
Hey Experts,

My question is the following.  I am working on an excel worksheet in Excel 2013.  It is a collection of contact information, name, address, etc.  The address includes the State field in a column (Arizona, California, New York, etc.)  I can filter the data and determine the number of records that are in California.  This is a time consuming process if I need to go through all 50 states.  Wondering if their is a quicker way to perform this thru Excel without any extensive programming?
0
Comment
Question by:idejjedi2
4 Comments
 
LVL 25

Accepted Solution

by:
ProfessorJimJam earned 500 total points
ID: 40455219
put all unique states in a range lets say in another sheet2 starting from A1 then use countif

=countif(therangeofyourcolumninSheet1 , A1)  then copy the formula and drag down. so you will get the count for each states
0
 
LVL 69

Expert Comment

by:Qlemo
ID: 40455225
You can add a column with "=countif(StateColumn, StateColumnCell)" and dragging it down. Of course you cannot sum that column ;-).
0
 

Author Closing Comment

by:idejjedi2
ID: 40455322
Thanks Professorjimjam.  That worked well.   I do not ask many questions.  One last follow up - if not too much trouble.  How do the points get assigned?  I saw that the 500 points was stated for this question.  Is that a large amount, a small amount?  Is their a link on Experts Exchange that will answer my basic questions on how the point system works and the protocols?  Thanks again...
0

Featured Post

ScreenConnect 6.0 Free Trial

Discover new time-saving features in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Rename multiple files in folder from list in table/excel. 4 37
VBA Help 18 45
Msbbox Notice (4 days) 27 59
Saving excel document in lotus script 4 13
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question