Previous Topic Next Topic

Count values without putting value in formula

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 -
Hello,
i am trying to count if a value occurs more than once in a column in Excel
For example, if i have a column of numbers like shown below
23456
76543
23456
56453
You can see the 23456 occurs twice
How would i count that there are two without incorporating any of the numbers within the formula, so it will automatically pick up if the same number occurs. Is this possible?

1 reply

Answer 1 / 1
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 768
So are you trying to find how many times numbers are repeated in a column ?

23456
76543
23456
56453
56453
56453

= 5 ?
Ask a question