Well the issue is that in the spreadsheet, there may be a mfg # that is used
by several manufacturers or a description that is used by several
manufacturers. What I need to do is say, there are 14,000 records... i need
to calculate the loss on based on the mfg #, but the mfg # must match the
same manufacturer and description. There may be a total 0f 15 row of Data
that have the same mfg #, manufacturer and description... 5 rows purchases at
$0.01 as the unit price, 5 rows show purchases at $0.05 as the unit prices
and 5 rows show purchases at $0.08 as the unit price.... what is the
difference if we would have purchased all 15 at $0.01 as opposed to what we
actually purchased.... I hope I clarified...
--
Thank you very much for your help!!! I really appreciate it :o).


"Dave F" wrote:

Well, there's probably a way. When you say you want to test if the
manufacturer, description and mfg# match, what do you mean? That they equal
each other? That they match another criteria?

Dave
--
Brevity is the soul of wit.


"Dee" wrote:

I have a worksheet where I have the following columns: INVOICENUMBER, TYPE,
INVOICEDATE, BILL-TO, COSTCENTER, PRACTICENAME, ADDRESS, CITY, STATE, ZIP,
MFGNO, MANUFACTURER, DESCRIPTION, ITEMNO, UNIT, QTYSHIP, UNITPRICE, AMOUNT.
I have tried several different approaches to manipulate this data. Now I
want to see if there is a way to say... If the manufacturer, description, &
mfg # match, take the lowest unit price and multiply that by the sum of the
quanitity then subtract that from what the actual total of the amount spent
(sum of amount) and the result would be the loss of $$ due to purchasing at
those higher prices. How can I do this... even if it is not all in one
formula, there has to be a way.

--
Thank you very much for your help!!! I really appreciate it :o).