Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Group By
Can I mark a table in Word to Group By the data. So it does not show
duplicate data? Thank You, Derek Hart |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Group By
See Example 4 in the article "Finding and replacing characters using
wildcards" at: http://www.word.mvps.org/FAQs/Genera...gWildcards.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Derek Hart" wrote in message ... Can I mark a table in Word to Group By the data. So it does not show duplicate data? Thank You, Derek Hart |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Group By
I looked at example 4. I don't understand how that applies. I have a list
of 27 states, but only 4 are unique. How do I list the 4? Derek Hart "Doug Robbins - Word MVP" wrote in message ... See Example 4 in the article "Finding and replacing characters using wildcards" at: http://www.word.mvps.org/FAQs/Genera...gWildcards.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Derek Hart" wrote in message ... Can I mark a table in Word to Group By the data. So it does not show duplicate data? Thank You, Derek Hart |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
Group By
If your list is in the form of one item per paragraph, then select the
list and click Table Sort OK. This sorts them so all the duplicates are grouped together. Then run the wildcard replacement to remove the duplicate paragraphs. What's left will be the unique items. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. On Sun, 8 Jan 2006 08:43:52 -0800, "Derek Hart" wrote: I looked at example 4. I don't understand how that applies. I have a list of 27 states, but only 4 are unique. How do I list the 4? Derek Hart "Doug Robbins - Word MVP" wrote in message ... See Example 4 in the article "Finding and replacing characters using wildcards" at: http://www.word.mvps.org/FAQs/Genera...gWildcards.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Derek Hart" wrote in message ... Can I mark a table in Word to Group By the data. So it does not show duplicate data? Thank You, Derek Hart |
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
Group By
It does not seem to replace all the duplicates unless I run it multiple
times. This is the code when I recorded a macro. I had the following: AZ AZ CA CA CA CA CA FL FL GA so I want to get AZ CA FL GA Selection.Find.ClearFormatting Selection.Find.Replacement.ClearFormatting With Selection.Find .Text = "(*^13)\1" .Replacement.Text = "\1" .Forward = True .Wrap = wdFindAsk .Format = False .MatchCase = False .MatchWholeWord = False .MatchAllWordForms = False .MatchSoundsLike = False .MatchWildcards = True End With Selection.Find.Execute Replace:=wdReplaceAll Am I missing something? "Jay Freedman" wrote in message ... If your list is in the form of one item per paragraph, then select the list and click Table Sort OK. This sorts them so all the duplicates are grouped together. Then run the wildcard replacement to remove the duplicate paragraphs. What's left will be the unique items. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. On Sun, 8 Jan 2006 08:43:52 -0800, "Derek Hart" wrote: I looked at example 4. I don't understand how that applies. I have a list of 27 states, but only 4 are unique. How do I list the 4? Derek Hart "Doug Robbins - Word MVP" wrote in message ... See Example 4 in the article "Finding and replacing characters using wildcards" at: http://www.word.mvps.org/FAQs/Genera...gWildcards.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Derek Hart" wrote in message ... Can I mark a table in Word to Group By the data. So it does not show duplicate data? Thank You, Derek Hart |
#6
Posted to microsoft.public.word.tables
|
|||
|
|||
Group By
Hi Derek,
You're not missing anything, other than the part in the web page that says "Repeat until nothing is found, to delete all duplicate paragraphs in the document". The recorder isn't capable of creating a macro that loops, so you have to add that to the code manually. Change the line Selection.Find.Execute Replace:=wdReplaceAll to Do While Selection.Find.Execute(Replace:=wdReplaceAll) Loop -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. On Sun, 8 Jan 2006 16:24:18 -0800, "Derek Hart" wrote: It does not seem to replace all the duplicates unless I run it multiple times. This is the code when I recorded a macro. I had the following: AZ AZ CA CA CA CA CA FL FL GA so I want to get AZ CA FL GA Selection.Find.ClearFormatting Selection.Find.Replacement.ClearFormatting With Selection.Find .Text = "(*^13)\1" .Replacement.Text = "\1" .Forward = True .Wrap = wdFindAsk .Format = False .MatchCase = False .MatchWholeWord = False .MatchAllWordForms = False .MatchSoundsLike = False .MatchWildcards = True End With Selection.Find.Execute Replace:=wdReplaceAll Am I missing something? "Jay Freedman" wrote in message .. . If your list is in the form of one item per paragraph, then select the list and click Table Sort OK. This sorts them so all the duplicates are grouped together. Then run the wildcard replacement to remove the duplicate paragraphs. What's left will be the unique items. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. On Sun, 8 Jan 2006 08:43:52 -0800, "Derek Hart" wrote: I looked at example 4. I don't understand how that applies. I have a list of 27 states, but only 4 are unique. How do I list the 4? Derek Hart "Doug Robbins - Word MVP" wrote in message ... See Example 4 in the article "Finding and replacing characters using wildcards" at: http://www.word.mvps.org/FAQs/Genera...gWildcards.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Derek Hart" wrote in message ... Can I mark a table in Word to Group By the data. So it does not show duplicate data? Thank You, Derek Hart |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
One Big Group Operation? | New Users | |||
Macro Security Through IT Group | Microsoft Word Help | |||
Group Policy File locations | Microsoft Word Help | |||
Text box - group | Microsoft Word Help | |||
Removing a group of hypertext links or all hypertext links in a document | Tables |