Hello, I am new to this forum and this is my first post.
I use a formula to calculate number of occurrences a record appears in a column.
Example:
Column A consist a list of items from A2 to A65000. Column B is the description, Column C is the formula copied down to the end of C65000.
=countif($A$2:$A$65000,A2).
I would expect that the count is correct. And, for most of the items it is, however it is not always. Right now, in this spreadsheet I have one item that shows a resulted count of it 3 times. It appears only once.
Is this a known bug in Excel?
Or, there is something wrong with the formula count? I don't think the formula is wrong.
Your help is greatly appreciated.
Bookmarks