View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Daniel[_10_] Daniel[_10_] is offline
external usenet poster
 
Posts: 7
Default 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