PDA

View Full Version : Solved: Count rows which are identical with a cell



hunsnowboard
02-06-2009, 11:17 AM
Hi there Everyone. Probably my question is easy, but I ended up with a very messy solution and I am sure that there is an easier solution.
I have a codenumber in cell "B3". Then there is column "A" which contains the codenumbers (around 60.000 codenumbers). I would like cell "C3" count and to display how many times is the codnumber in "B3" in the column "A".

(My solution was to delete all the cells which are not equal to the "B3", and then count what is left, which is not a good as I need the column.)

Thank you in advance and have a nice weekend all!

Bob Phillips
02-06-2009, 11:54 AM
=COUNTIF(A:A,B3)

hunsnowboard
02-06-2009, 12:08 PM
HI Xld... :)) Yeah! Shame on me... I got so much into the vba, that I cannot think out of the box... Best solution is allways the most simple..right? :)
Thank you!