[Year 12 IPM] Re Excel problem

[Peter Ruwoldt (wrk)]

Does this do what you need?

Jock Garnsworthy 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

-- 
If computers get too powerful, we can organize them into a committee -- that will do them in.

Peter Ruwoldt
ICT Coordinator
Grant High School
Hosking Avenue
MOUNT GAMBIER  SA  5290

P. 08 87263107 (Do not leave voice mail)
F. 08 87250173

ruwoldtp at granths.sa.edu.au
http://waraku.blogspot.com/


-------------- next part --------------
A non-text attachment was scrubbed...
Name: countissue.xls
Type: application/vnd.ms-excel
Size: 32768 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/ipm/attachments/20060329/5738b827/countissue-0001.xls