Consulting

Results 1 to 3 of 3

Thread: Solved: Count rows which are identical with a cell

  1. #1

    Solved: Count rows which are identical with a cell

    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!

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    =COUNTIF(A:A,B3)
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •