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
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