Reply
 
Thread Tools Display Modes
  #1   Report Post  
istate2009 istate2009 is offline
Junior Member
 
Posts: 1
Default SKIP IF Duplicate

Hello!

I am trying to pull data from a source that has some duplicate entries (records) and I want to skip any records if a field value already appears in the previous records

Data Source
AC01 | Red | Blue | Green
AC01 | Blue | Yellow - Red
AC02 | Green | Blue | Green
AC02 | Blue | Red | Green

In the scenario above I would only want to print one of the AC01 rows and one of the AC02 rows. doesn't matter which one. Just want to remove the duplicate row based on column 1.

Not sure if this is even possible.

Thank you in advance
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
words skip around jar New Users 1 June 22nd 09 10:29 PM
Skip Numbering Paul Gauci Microsoft Word Help 20 January 22nd 09 12:21 AM
skip from one text box to another nuttie netballer[_2_] Microsoft Word Help 0 March 19th 08 10:59 AM
Skip if duplicate Sparkie Mailmerge 3 March 6th 08 10:26 AM
Skip Duplicate Records + Put all Records in One Document Ryan D Mailmerge 2 April 25th 07 06:55 PM


All times are GMT +1. The time now is 03:57 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"