[Year 12 IPM] Re Excel problem

[Geoff Moss]

Hi Jock

Try the attached solution in column C and then apply a countif function to 
column C as I have illustrated in your example.

Geoff Moss
RMIT


----- Original Message ----- 
From: "Jock Garnsworthy" <ga at willihigh.vic.edu.au>
To: <ipm at edulists.com.au>
Sent: Wednesday, March 29, 2006 8:01 PM
Subject: [Year 12 IPM] Re Excel problem


> 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/vnd.ms-excel
Size: 16896 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/ipm/attachments/20060329/05ad8a02/countissue.xls