Excluding Duplicates

[shepoodle]

Good Afternoon -

I have a list of data and there is a set that is duplicated. I am trying to create a page the summarizes by person how many orders were generated. For example

Person ABC 123456 Item 3
123456 Item 2
Person DEF 7891011 Item 1
12131415 Item 2
Person GHI 147852 Item 1
147852 Item 2
Person JKL 963852 Item 1
963852 Item 2

I would like for it to tell me:

Person ABC = 1
Person DEF = 2
Person GHI = 1
Person JKL = 1

Any assistance you can provide we would be greatly appreciated!

 

[SteveO59L]

why does person DEF score 2?

 

[shepoodle]

I apologize DEF should have 1. I did find a formula that I can use, to count the unique values, but now I need to make it specific to person ABC, DEF, GHI. I am using this formula to start...

=SUM(1/(COUNTIF('Raw Data'!$C$2:$C$2157,'Raw Data'!$C$2:$C$2157)))