View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Leith Ross
 
Posts: n/a
Default Need help creating a function


Hello Nander,

To determine the sales ranking corrrectly would require including the
cost of each item. Without using a weighted average, you can't actually
determine which item(s) is/are responsible for 80% of the sales in
dollars. The only time quantity would be an accurate gauge is when you
are being paid piece rate.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=514172