Auto fill

[dwarek]

Hello Everyone
I have been assigned a task to create a auto fill function. The task is I need to create a formula to search a particular alpha numeric word in a column and define how many times this word as appeared in that column. For example lets say a alpha numeric word called "MIKE1" in column A. In cell B2 I need to write a formula how many times "MIKE1" has appeared. So if this word as appeared 12 times in column A then I need the value 12 in cell B2. Can anyone help me out in this. Thanks in advance

 

[Fluff]

How about
=SUMPRODUCT((MONTH(B2:B18)=1)*(B2:B18<>""))

 

[dwarek]

hey
it returns value as 0 any other suggestions?
thank you

 

[Fluff]

It works for me

Excel 2013/2016
	B	C
1	Introduced
2	01/01/1980	3
3	01/10/2016
4	01/07/2005
5
6	01/07/1980
7	01/10/1987
8	01/12/1997
9
10	01/04/1986
11	01/04/1986
12	01/01/1980
13	01/01/1980
14	01/12/2000
15	01/06/1997
16	01/04/1985
17	01/04/1985
18	01/03/2004
Sheet5

Cell Formulas
Range	Formula
C2	=SUMPRODUCT((MONTH(B2:B18)=1)*(B2:B18<>""))