Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-07-2013, 12:51 AM
heidiau heidiau is offline how to show identical data once only? Windows 7 32bit how to show identical data once only? Office 2007
Novice
how to show identical data once only?
 
Join Date: Aug 2013
Posts: 1
heidiau is on a distinguished road
Default how to show identical data once only?


I created a table regarding competition application result with three columns of information, i.e. school name, student name and contestant no. by mail merge function. One school may have nominated more than one students for the competition. Is it possible to show the same school name in a merged cell once only?
Reply With Quote
  #2  
Old 09-29-2013, 07:44 PM
macropod's Avatar
macropod macropod is offline how to show identical data once only? Windows 7 32bit how to show identical data once only? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi heidiau,

You could do this with some field coding.
First, insert a field coded as follows at the top of your document:
{IF MERGESEQ = 1 {SET School " "}}
Then, where your existing mergefield is, replace it with a field coded as follows:
{IF{REF School}<> {MERGEFIELD School_Name} {MERGEFIELD School_Name} ""}
Finally, insert a field coded as follows at the bottom of your document:
{SET School {MERGEFIELD School_Name}}

The above assumes your mailmerge field is named 'School_Name' - change it to match the actual field name.

Note: The field brace pairs (ie '{ }') for the above example are created in the body of the document via Ctrl-F9 (Cmd-F9 on a Mac) - you can't simply type them or copy & paste them from this message.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple identical fields snorkerz Word 4 06-25-2012 02:30 PM
how to show identical data once only? Two identical reports - merge fields into one of them cyndor Excel 3 06-21-2012 06:24 PM
how to show identical data once only? Show Items with no data DeborahBartlett Excel 1 01-24-2012 01:10 AM
how to show identical data once only? Copy from one word document to another no identical gmurphy Word 3 09-07-2011 04:28 AM
Show different Data depending on Imput Value Aton Word 0 09-15-2010 03:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:16 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft