have column of years (numeric), would like tocount how many by decade.

[mr_techie]

Hi,

I am new to VBA, an thus may be a trivial question, but I haven;t founf an answer, yet.

I have a column of years, 1921 to 2011, and would like to find out hoe many are in each decade, ie >=1920 and <=1929, for each decade.

the column is in numeric form, but could be easily converted to text.

any help would be appreciated.

thanks in advance!!

 

[kreases]

Thanks that works, involves a lot more keying though. Not sure why the wildcards don't work in the Countif statement if anyone can answer that I would love to know

 

[RoryA]

Wildcards only work with text, not numbers.

 

[kreases]

Good to know, thanks