Filtering Data

[Denise H. via OfficeKB.com]

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?

 

[Doug Robbins]

You (or somebody else) has certainly made it difficult by arranging the data
in that way. It would be more normal to arrange it

Part No. Official Price Customer Price

Then it would be a simple matter to compare the entries in the Official
Price and the Customer Price fields.

Before trying to advise you how to do it with the data as you have it (which
will not be simple), is it possible to re-arrange the data as shown above?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Denise H. via OfficeKB.com]

Thanks for the reply. I'm not certain that I am doing this as efficiently
as possible. Perhaps it could be better acomplished in Excel, except that
I am more familiar with queries/filtering in Word. The official price
sheet is a fancy spreadsheet which contains pictures of the models, and
other data necessary for the sales team. I created a simpler chart of just
the parts and prices and then download the weekly order data from our
online database. Because all of the parts on the official price list are
not ordered every week, I am not able to simply copy the official prices
and paste them to the spreadsheet of orders.

 

[Doug Robbins]

Sounds more like something for which Access should be used.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP