Count number of times a number appears

Edgie

Board Regular
Joined
Aug 5, 2011
Messages
102
Hi,

I have a list of numbers going down like so, with some blanks

(A2) 10
(A3) 11
(A4)
(A5) 10
(A6)
(A7) 10

In cell (A1) i would like to be able to put a number in to see how many times that number has appeared in the data below (from a2 onwards).

However in the next cell i would like to show how many times that number has occured.

e.g the number i want to count is 10,

so A1 i put 10
(A2) 10 (B2) 1
(A3) 11
(A4)
(A5) 10 (B5) 2
(A6)
(A7) 10 (B7) 3

I probably havent explained myself very well....so apologies.

Thanks

Matt
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Edgie

Board Regular
Joined
Aug 5, 2011
Messages
102
Thanks very much for the responses....i'm not sure they are working.

The first formula counts how many times that number occurs. Not quite what i'm after.

I need to see what occurance of a selected number has occured in the list.

I have a range of numbers but i want to be able to choose what number i want to see how many times it has occured been in the range of numbers. So for this exmaple i input the number i want to see how many times it has occured in the range below. So in (A1) i type 10 and next to all the 10's in the range (a2) onwards, next to it will show how many times it is occured, so the first 10 will have 1, the next 10 will have 2 etc

(A) a user defined number - e.g 10
(A2) 10 (B2) 1
(A3) 0 (B3)
(A4) 7 (B4)
(A5) 10 (b5) 2

Thanks for you help guys
 

Watch MrExcel Video

Forum statistics

Threads
1,127,633
Messages
5,626,002
Members
416,150
Latest member
Dawzzy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top