View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Noel Noel is offline
external usenet poster
 
Posts: 35
Default Count Unique Items

I want to count the unique items in a list where a related field matches
another criteria. For example,

A B
1 orange bob
2 orange sue
3 orange hank
4 la ted
5 la ted
6 la ted
7 la joe
8 orange bill
9 orange deb
10 orange sue
11 orange bill

I want to count how many unique people there are in Orange.