| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do I count the number of times a word is repeated in a range?
|
|
#2
|
|||
|
|||
|
Adapted from Dave Peterson's fine earlier post...........
=SUMPRODUCT(LEN(A1:C101)-LEN(SUBSTITUTE(UPPER(A1:C101),UPPER(D1),"")))/LEN(D 1) Vaya con Dios, Chuck, CABGx3 "sol" wrote in message ... |
|
#3
|
|||
|
|||
|
Try here http://www.vbaexpress.com/kb/getarticle.php?kb_id=235 or here http://www.vbaexpress.com/kb/kblist.php Hope this helps -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287 View this thread: http://www.excelforum.com/showthread...hreadid=387033 |
|
#4
|
|||
|
|||
|
sol Wrote: I use =COUNTIF(D10:D100, "YES"). It works pretty good -- Ltat42a ------------------------------------------------------------------------ Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735 View this thread: http://www.excelforum.com/showthread...hreadid=387033 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
| How do i count the number of conditional formatted cells? | Excel Discussion (Misc queries) | |||
| Count number of occurences in 1 column only if something in anothe | Excel Worksheet Functions | |||
| Whats the function to count the total times a word is displayed | Excel Discussion (Misc queries) | |||
| Can the number of times undo is used in Excel 2002 be increased? | Setting up and Configuration of Excel | |||
Linear Mode
