Home |
Search |
Today's Posts |
#1
|
|||
|
|||
What is the formular that will count IF a specific word is found,.
What is the formular that will count IF a specific word is found in a word
table column, such as 'YES'? |
#2
|
|||
|
|||
COUNTIF, but it's in Excel, not Word.
-- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "JakeW" wrote in message ... What is the formular that will count IF a specific word is found in a word table column, such as 'YES'? |
#3
|
|||
|
|||
Jake,
Maybe you could use a macro something like: Dim oTable As Table Dim oRng As Range Dim oCell As Cell Dim pContent As String Dim i As Integer Dim rowLast As Long Set oTable = ActiveDocument.Tables(1) rowLast = oTable.Rows.Count i = 0 Set oRng = oTable.Range For Each oCell In oRng.Columns(1).Cells pContent = oCell.Range.Text pContent = Left(pContent, Len(pContent) - 2) If pContent = "Yes" Then i = i + 1 End If Next ActiveDocument.Tables(1).Cell(rowLast, 1).Range.Text = i End Sub |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Specific Email Merge w/ Specific Attachements | Mailmerge | |||
need to count word total for 1200 documents | Formatting Long Documents | |||
Ideas for macro to add row for count and percentage | Tables | |||
INCLUDEPICTURE --> able to include all images in a specific direct | Mailmerge | |||
Change Line Count to not count blank lines | Microsoft Word Help |