Excel formula

Excel formula

Closed - This job posting has been filled and work has been completed.

Job Description

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.
thanks

Open Attachment