Microsoft Office Word Forum - WordBanter

Microsoft Office Word Forum - WordBanter (http://www.wordbanter.com/index.php)
-   Mailmerge (http://www.wordbanter.com/forumdisplay.php?f=6)
-   -   SKIP IF Duplicate (http://www.wordbanter.com/showthread.php?t=157474)

istate2009 February 27th 20 05:30 PM

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


All times are GMT +1. The time now is 05:02 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
WordBanter.com