Filtering Data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Denise H. - 12 May 2005 20:47 GMT

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?

Reply to this Message

Doug Robbins - 13 May 2005 07:07 GMT

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?

Signature

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

>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
[quoted text clipped - 14 lines]
> I believe it would be done with some sort of nested command but I am not
> sure how to set it up. Any advice?

Reply to this Message

Denise H. - 13 May 2005 16:42 GMT

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.

Reply to this Message

Doug Robbins - 13 May 2005 21:47 GMT

Sounds more like something for which Access should be used.

Signature

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

> 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
[quoted text clipped - 6 lines]
> not ordered every week, I am not able to simply copy the official prices
> and paste them to the spreadsheet of orders.

Reply to this Message