Unique Values

[WebKill]

I'm hoping a formula can do this, as I can’t use a script in this instance, but I can't seem to figure it out if it is possible.

I have two columns of data, a listing of names and a list of numbers (there is other data, but only these two are important. For example

number, name, area
1, John, 1
2, John, 1
3, Bill, 1
4, Sam, 2
5, Sam, 2

I need the number of unique names in an area, in this instance area 1 would be 2 (John and Bill). I just need the count. It is likely that each unique name will only be in one area, so in this instance, John would not have a record further down with area 2, only 1.

I have been able to figure out how to get a count of unique names, but I can’t correlate it per area.

My hope is for someone with little excel experience to paste information in another sheet, then look at the summary sheet to get statistics.