Hi
I have the following excel sheets:
SHEET1:
This is my data sheet that refresh from external source
A B C D
1 Instance InventoryID Date Price
2 001 200 2010/09/09 5.23
3 002 201 2010/09/10 7.89
4 003 202 2010/09/10 5.23
5 004 202 2010/09/11 5.99
6 005 200 2010/09/12 5.00
7 006 201 2010/09/13 8.05
PS: I have about 8000 InventoryID's and about 90000 Instances and need to use all information
SHEET2:
This sheet I want to check what stock item (InventoryID) I received at latest price (not highest)
A B C
1 InventoryID Date Price
2 200 2010/09/12 5.00
3 201 2010/09/13 8.05
4 202 2010/09/11 5.99
I tried with pivot table in the following manner:
Used my (InventoryID) as "Row Labels"
Used my (Price) as "Values"
Tried using (Date) in "Column Labels" but excel says "USE LESS DATA" so I went without this
I then try and set (Price) in "values" to report only the latest but I can only choose max/min/sum and this is not what I want....
Please help
Bookmarks