Counting Data in a 2-column Array (with Duplicates)

Hi,

http://i33.tinypic.com/2zyadn8.jpg

I'm trying to write a formula that counts the number of Dates on which Interviews took place.

Dates are listed in C2:C9. Comm Types are listed in A2:A9, "Interview" is one possible Comm Type.

I want the formula to sort through the Comm Types in A2:A9, accept entries that are "Interview", then count the corresponding number of Dates on which these Interviews occurred AND only count Duplicates once.

So the formula should think like this:

------ A -------- C ----
5 - Interview - 8/14/08
6 - Interview - 8/14/08
8 - Interview - 8/16/08

And return the answer for "Number of Interview Days" = 2

8/14/06 and 8/16/08


Any ideas? I'm still a beginner but I think this some kind of Array Formula with one of the COUNT functions might work, but I haven't got it yet.

for your range try

Please Login or Register  to view this content.

its an array ,confirm with ctrl +shift+enter
it should then be surrounded by {}