R.VENKATARAMAN Wrote:
=COUNTIF(A1:A7,"*d")

assuming these entries are in a1 to a7

thanks VENKATARAMAN,
as i said , am new to excel.. so where should i need to give the code
mentioned?
i know its silly

waiting for ur responce ..

thanks,
ja

--
jayender.v
-----------------------------------------------------------------------
jayender.vs's Profile: http://www.excelforum.com/member.php...fo&userid=2864
View this thread: http://www.excelforum.com/showthread.php?threadid=48303