Average - 3 months / 6 months trend line ( array formula? )

[ccernat]

Hello guys,

In the attachment you will find 2 sheets: TRENDLINE - TABLA and VALUE ENTRIES. In the first sheet, TRENDLINE, i have as rows a list of item codes, and as columns some headers for Avg. unit price / 3months and 6months.

For each item code in the TRENDLINE, there are n numbers of transaction by date in the Value Entries sheet, and each transaction has a Cost per Unit column with data. Now, based on the Date of today - 3 months or 6 months, i want to calculate the average for each item in the TRENDLINE LIST, and also if possible, to have some visual signs with UP, DOWN, or - depending on the trend of the Cost per unit.

I tried all kind of tricks, but mostly manual, i need something automatic, because the tables are querying a database for the data.

Tks ALOT!!