Hello,
i am trying to count if a number occurs more than once in a column
For example, if i have a column of numbers like shown below
23456
76543
23456
56453
65445
You can see the 23456 occurs twice
How would i count that there are two, without incorporating any of the numbers in the column within the formula, so it will automatically pick up that there are two numbers the same. Is this possible does anyone know?
Hi,
Presuming your data starts at A1, put this in B1
=COUNTIF(A:A,A1)
and copy it down the length of your data.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Thank you that was helpful but can you help me again please
I will have a long list of say 1000 numbers and let's say three are the same, but i don't know which three, is there any way to automatically tell me that?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks