THANKS! & SUCH A SPEEDY REPLY - I'm a Newbie to using these user groups and

Excel - but this looks like it will work - it will be late tonight before I

get to implement these details, but it looks like the right answer - Thanks

for the HELP.

Wayne M

"WIM4246" wrote:

This looks like the right track that I should be doing, but it notice now

that the Info refers to Access, and I thought that I had submitted my

question as an New Excel user.

If these instructions are to also work in Excel, I guess I'm not proficient

enough to apply the terminology correctly, because I'm not even getting a

formula recognitxion error - but I'm trying to run these functions from a

cell within my Excel Work Sheet.

Can you explain or give a short example of the syntax and where I should be

entering it?

Thanks, Wayne M

Can it be entere into the same Work Sheet - as in a cell following the Data

Column -

& where does the "Range" of the Data Selection to be used get entered?

ince you posted your question in an Access database forum I read it as

referring to an Access problem. If you're using Excel, you should ask in

an Excel forum. But first, try using a formula like this in a cell to

the right of one of your "1,2,1,A,C" values - which I'll assume is in

cell A2:

=CountOccurencesInDelimString($A2, "1", ",")

Then fill down the column with the same formula (so the references

adjust to $A3, $A4...).

Next use a =SUM() formula at the foot of this column: that should give

you the count of "1"s.

Repeat in adjacent columns for the other values you want to count.

On Sat, 2 Oct 2004 22:37:01 -0700, "WIM4246"

< XXXX@XXXXX.COM > wrote:

Please respond in the newgroup and not by email.

referring to an Access problem. If you're using Excel, you should ask in

an Excel forum. But first, try using a formula like this in a cell to

the right of one of your "1,2,1,A,C" values - which I'll assume is in

cell A2:

=CountOccurencesInDelimString($A2, "1", ",")

Then fill down the column with the same formula (so the references

adjust to $A3, $A4...).

Next use a =SUM() formula at the foot of this column: that should give

you the count of "1"s.

Repeat in adjacent columns for the other values you want to count.

On Sat, 2 Oct 2004 22:37:01 -0700, "WIM4246"

< XXXX@XXXXX.COM > wrote:

Please respond in the newgroup and not by email.

1. Table of cells contains comingled text (A,B,C,1,2,3)-formated as .

2. linking a cell containing text to another cell containing text / data

4. How do I sync person A's contacts with person B's?

6. how do u invoke Tag b's Tag Handler from within Tag a's tag Handler?

7. Moving User A's E-Mail to User B's in Exchange2003

8. Why does Form-A's instance fire Form-B's event??

9. regexp for reg language that has an even number of a's and b's

10. Linking cells containing text from one worksheet to a cell with text in another worksheet

11. A changing user B's password so user A could log in under user B's identity.

12. read text from html table cell containing and anchor tag

13. Convert UNIX formated text files to DOS formated?

14. how can I delete cells containing text within a range of cells

15. Cells formated as numbers are calculating like text

3 post • Page:**1** of **1**