well it seemed a simple task

**bigtounge1** · 04-03-2005, 06:18 PM

well i hought this would be simple but nothing I've tried works. Here's what i have:

lets call cell A2 the info block
lets call B1 a refrence cell
and B2 is where i need the work done

Cell A2 is a dialog type cell. serveral names and dates and info are in the cell
Cell B1 is a name pulled from another worksheet.
in cell B2 I need a formula that will count the number of times name A (B1) show up in cell A2(paragraph).

Another aspect of the worksheet that i could probably get after i fix this probleem is :

Cell B3 is a month i need to pull B2 if B3 = referenced month on a table.

Anyone ... I hate my boss lol

**olasa** · 04-03-2005, 06:44 PM

Try this,

1) To count the number of times a name occurs
=(LEN(A2)-LEN(SUBSTITUTE(A2,B2,"")))/LEN(B2)

2) Referenced month
B3: Jan
H10: a date 1/1/2005
Table
Jan
Feb
...
Dec

=IF(MATCH(B3,Table,0)=MONTH(H10), ... , "")

Hope this helps

Ola Sandström

**bigtounge1** · 04-04-2005, 07:23 AM

well for some reason it's giving me a decimal value. It should return 14 but it gives me 13.83. In another cell it should be 2 and it returns 1.8423. Also, every time i enter a formula it says I need to enable macros? My head hurts...