Forum Discussion
Excel Countif - actual counter
Dear all, could you please help me? I am using Countif function in the column next to database and it is giving me just the total counts but is there any other function which can give me exact c...
I think this is what you're looking for. I changed the formula you had so that it's only looking at column A for the current and preceding rows. The way you'd written it it was always comparing the value in the current row with all rows.
Your original: =COUNTIF(A:A,A2)
Corrected: =COUNTIF($A$2:A2,A2)
The absolute reference $A$2 anchors the range, and then allows the other (relative) one, A2, to change as it is copied down the column.
But I am making the assumption that this is what you wanted because it does deliver the number you seem to want. You didn't actually describe HOW you arrived at your "Requested data" manually. So I made an inference which did come up with the same answers....that still could be coincidence.
- thanks, clear, muchly appreciated.
