Thread: Find Variance
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DEE DEE is offline
external usenet poster
 
Posts: 250
Default Find Variance

Ok.. don't know if the terminology is correct, but basically what I need to
do is... I have found all of the manufacturer's products where they have
charged us different unit prices. I will need to prioritize them so that we
work on the items with the most significant difference in price so we don't
waist our time on $0.01 difference instead of $100.00 difference.

Problem is there are 820 line items. One product number may have 3
different unit prices or another product number may have 2 different unit
prices. How can I find the difference between the unit prices when there are
820 line items and each product will have at least 2 unit prices, but may
have more than 2???? Please let me know if you have any ideas. Thanks.