Quote:
Originally Posted by David Heaton[_2_]
On May 4, 5:41*am, MM wrote:
Afternoon all,
You've helped out before and I come to you again. *Here's the question....
5 worksheets in my workbook, each representing a different office.
Column A for each worksheet is the date in the following format: 03-May-10.
|
Hi,
one alternative approach. using wild characters with countif function
If you want to count the occurence of MAY in sheet2,
=COUNTIF(Sheet2!A1:AZ60000,"*May*")
similarly you can use, "??May*" etc.
Thanks
Bala