Thread: Filtering Data
View Single Post
  #1   Report Post  
Denise H. via OfficeKB.com
 
Posts: n/a
Default Filtering Data

I have an Excel spreadsheet which contains the part numbers and prices from
our official price list and from orders received from customers. I need to
determine if the customer has used the correct price on their order. The
spreadsheet has 2 columns, price & part. I'd like to set up my merge such
that if the part & price match the next record, those records are skipped.
For example, in the spreadsheet below, only the last item would show up in
my merged Word document.

Price Part
$23.00 A100S
$23.00 A100S
$2.25 A3A07S
$2.25 A3A07S
$3.58 A314BLKS

I believe it would be done with some sort of nested command but I am not
sure how to set it up. Any advice?