[Year 12 IPM] Re Excel problem

[Jock Garnsworthy]

Hi Peter,

The attached file probaly explains better what I am after.

Cheers

Jock


On 29/3/06 7:39 PM, "Peter Ruwoldt (wrk)" <pruwoldt at bigpond.net.au> wrote:

> i do not think that there is a function that will count the number of 
> times a particular character appears in a cell which is what I 
> understand is the problem.  countif certainly will not do that.  You 
> would need to have a working area that broke the cell up into individual 
> characters using probably the  mid() function and then use countif to 
> tallly the number of times that a particular character appeared in that 
> area. 
> Peter
> 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: countissue.xls
Type: application/vnd.ms-excel
Size: 33794 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/ipm/attachments/20060329/8024f3d3/countissue-0001.xls