Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel 2010 - Need to count instances of particular numbers in a region of cells

Posted on 2016-10-22
3
Medium Priority
?
79 Views
Last Modified: 2016-10-26
I have a region of cells a1: p116. (See attached workbook.)
This region contains numbers between 1 and 50.  Some of them are duplicates.
Underneath the region, I'd like a count of how many times:
-  the number 1 appears.
-  the number 2 appears.
-  the number 3 appears.
etc.
instances.xlsx
0
Comment
Question by:brothertruffle880
  • 2
3 Comments
 
LVL 33

Accepted Solution

by:
Subodh Tiwari (Neeraj) earned 2000 total points
ID: 41855125
Try this.....
In C118
=COUNTIF($A$1:$P$116,B118)

Open in new window

and copy down.
1
 

Author Closing Comment

by:brothertruffle880
ID: 41860552
Thanks!
0
 
LVL 33

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41860912
You're welcome. Glad to help.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
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.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

927 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