My formula *does* work.

In fact, all the suggested formulas work.

BUT, you must realize, that when we make suggestions, we test them on data
and values that you have posted.

The only way that we could test your data, was to *key* it into the cells.

If you would create a small list, as you posted, and try all of our
formulas, you would see that they all do as you requested.

HOWEVER, I would bet that your data is *not* keyed into your data list, but
probably put there as the result of some formula, or perhaps even imported
from another program or the net.

Since you make no mention of how your cells are populated, we can only make
suggestions with the information that you give us.

NOW, how is your data list populated?
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------


"smilroy " wrote in message
...
Hi,

Sorry but none of these formulas worked. These will only return the
number of aa.bb that exist but it still does not include occurrences of
aa.bb.cc.dd.ee. Excel does not recognize aa.bb.cc.dd.ee as an
occurrence of aa.bb

I don't need this to be an exact match. I need it to identify the
anything that starts with aa.bb.

For example:

aa.bb is counted

aa.bb.cc should also be counted

as well as,

aa.bb.cc.dd.ee

etc...

Thanks,

Scot


---
Message posted from http://www.ExcelForum.com/