mr kus cse formula {=SUM(--ISNUMBER(FIND(CHAR(ROW($97:$122)),LOWER(B3))))--ISNUMBER(FIND(" ",B3))} yang dihitung banyak huruf yang digunakan [a-z], tidak case sensitive + spasi [dihitung 1 kali]
- abimono - love is a mammalian drive http://abimono.blogspot.com/2007/02/loveless_07.html http://abimono.blogs.friendster.com/abimono/2007/02/loveless.html _________________________________________________________________________ [http://abimono.blogspot.com/ ] [http://www.friendster.com/abimono ] [ www.abimono.com] [http://xl-mania.blogspot.com/ ] [http://www.friendster.com/xlmania ] [ www.XL-mania.com] On 2/9/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Pak Abimono, Kalo mau tahu jumlah keseluruhan jumlah alphabet termasuk spacinya gimana
formulanya ?
Thank's Kus
count_char.xls
Description: MS-Excel spreadsheet