Count the number of cells with text below a number and output the result in separate columns
Posted on 2013-05-16
I have a fairly straightforward problem - unfortunately, I am in a bit of a time crunch. The issue is that have one column of cells which contain either cells with only numbers or cells that are mostly text but may include a number at the beginning of the variable - the last character would always be text though.. I need to count the number of cells with text in them below each cell that contains a number and then write the count beside that cell with the number in it. For example here is my column:
So what I would like to end up with is a macro or vba routine that will output the following in a different columns nearby:
This is just a sample - the actual column contains approximately 3400 cells with probably approx 2000 containing numbers with varying numbers of cells below each of them containing text (and perhaps starting with a number).