Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I omit a duplicate field in a merged document?
I want to merge a list from Excel to a Mail Merge in Word. It works, but
there are fields that are duplicates in Excel that I do not want in Word. For example, Mr. Smith has two lines of information in Excel which generages two letters in Word. Is there a way to eliminate this? |
#2
|
|||
|
|||
You could add a column in which you count the occurrences of each entry.
For example, if you have a customer number in column A, enter the following formula in row 2, and copy down to the last row of data: =COUNTIF($A$1:A2,A2) When merging in Word, filter this column for rows with a 1. dawnlin wrote: I want to merge a list from Excel to a Mail Merge in Word. It works, but there are fields that are duplicates in Excel that I do not want in Word. For example, Mr. Smith has two lines of information in Excel which generages two letters in Word. Is there a way to eliminate this? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I show all field data in a pivot table, instead of blank | Excel Discussion (Misc queries) | |||
requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
Stop text from stringing into next field when empty | Excel Worksheet Functions | |||
Stop text from stringing into next field when empty | Excel Worksheet Functions | |||
Pivot Tables..I give up... | Excel Worksheet Functions |