Help with a count formula

[Heaney]

Hi all,

I am in need of help with a formula to count unique values that are in column A, based off a value in a different column.

Column A is a list of tracking numbers that are repeated numerous times and I want to count only the unique values. Column D will be the same "scanID" number for each of the tracking numbers in Column A. I'd like to be able to perform a search based on a value in Column D to count in Column A.

 

[Heaney]

In that case put an apostrophe in front of the number in E7

Thank you so much for your help with this! This solved it.

 

[Fluff]

Glad we could help & thanks for the feedback.