Need help with formula or code for count "Thanks"

[Javi]

Hi All, Thanks for reviewing my question.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I have a very unique situation that I don't know how to attack.
<o> </o>
Column “A” has multiple duplicates that represent part numbers
Column “D” has multiple duplicates that represent price each
<o> </o>
What I need to do is take the matches in Column “A” and the corresponding price in Column “D” and return and average or price and delete all lines but one.

If deleting the lines is a problem then I can do manual.

Thanks.

 

[Javi]

Oops Correction:

What I need to do is take the matches in Column “A” and the corresponding price in Column “D” and return and average price in column "E". I would like to delete all lines but one.