Excel formula

Closed - This job posting has been filled and work has been completed.
Fixed Price
Deliver by - October 28, 2012


Need an excel formula that will automaticlly remove duplicates referncing "data" sheet column H (year) and appearing in report data column A.

I could not think of a way to do this myself, just need the formula.

Please note: do not use a formula that only looks at number as I may apply this to other situations.