I have a Table like this
The same ITEM may have multiple different price at different timePlease Login or Register to view this content.
For example
ITEM
668CY9YX56Y
has different price shown as below
How do I calculate below: ??Please Login or Register to view this content.
Each Item's Most Recent Price Average
Each Item's Past one Month Price Average
Each Item's Past 6 Months Price Average
Thank you so much
Example File is here
http://dl.dropbox.com/u/23447837/ExcelForumA.xls
Bookmarks