Serach for numbers starting with for example 49****???
Hi all,
i have a small problem. And it follows like this:
I create a new workbook, wich will contain a couple of charts based
upon data from 10 other workbooks.
I need to search two columns for 2 things. one should search for a
month, and then count all numbers in the other column, within that
month wich starts with 49!!
Example:
A b
4900 Jan
3800 Jan
4901 Feb
4911 Feb
2000 Feb
So the code should in this case display:
Jan Feb
1 2
How do I this???
Would appreciate any help, Daniel
|