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!
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!