[Year 12 IPM] Re Excel problem

[P. Barrera]

Hi Jock,

Here we go. I hope this is what you really need.

See attached file

Cheers,

Patricio


At 09:01 PM 29/03/2006, you wrote:
>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
> >
>_______________________________________________
>http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
>IPM Mailing List kindly supported by
>http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority and
>http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers 
>Association Inc
-------------- next part --------------
A non-text attachment was scrubbed...
Name: countissue.xls
Type: application/octet-stream
Size: 16896 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/ipm/attachments/20060329/eae20ef3/countissue-0001.obj