Solved

Excel 2010:  Count

Posted on 2013-06-20
4
442 Views
Last Modified: 2013-06-20
Hi Experts!  I need a formula that will count how many times a name appears in column A.  For example after I sort that column from A to Z i need to get a count of hown many times that username appears.   I could do this manually but that column is about 2000 rows, it would take forever.

JDOE
JDOE
JDOE
         3 imes

Thank you.
0
Comment
Question by:itsmevic
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 23

Assisted Solution

by:NBVC
NBVC earned 175 total points
ID: 39263696
Do you want a count in an adjacent column using a formula like:

=COUNTIF(A:A,A1) copied down

If you want a count below each name after sorting, you can use SUBTOTALS from the Data Menu.. select Count at the Use Function field.. ensure correct column is selected at the top and check same column in the bottom section...

If you want a table of all names and counts separately, you can use a Pivot Table... Insert|Pivot table, then drag the name to the Row area, and the Name again to the Summation area... it should give count of each name.
0
 
LVL 25

Assisted Solution

by:Ron Malmstead
Ron Malmstead earned 165 total points
ID: 39263698
=COUNTIF(A1:A2000,"JDOE")
0
 

Assisted Solution

by:mrbcam21
mrbcam21 earned 110 total points
ID: 39263725
=COUNTIF(A:A,"JDOE")
0
 
LVL 24

Accepted Solution

by:
Steve earned 50 total points
ID: 39263847
****  just read NB_VC after posting this one  ****
**** I agree with him that you should use pivot table  ****

Essentially same as NB_VC... (so no point for me on this one)
Add a column header (if not there already) such as UserName
Highlight data in A:A including header and go to Data > Pivot table
Click OK
Drag the UserName Field into the Row area and the Sum (sigma symbol) area.

You should now have the list of usernames in order and with a count next to each.
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

739 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