I am looking for a function or group of functions that can help me count the
unique entries that meet two other criteria. The table is similar to:

Column A: Column B: Column C: Column D:
12346 Level1 ACME 345334
12346 Level1 ACME 34523
12346 Level2 ACME 34622
12376 Level2 ACME 3453
13255 Level2 DODAD 345
13548 Level1 THINGABOB 322562
12356 Level1 WIDGET 34622
12376 Level2 WIDGET 3453
12378 Level3 WIDGET 546443

Column A is a list of unknown ID numbers. Column B&C values are known. The
table is sorted by Column C, then Column B, then Column A, all in acending
order. What I want is to be able to look for a value in Column C & Column B,
and then count the unique items in Column A that matches with Column B & C.

Example:
If I search for "ACME" & "LEVEL1" I should get a result of 1.
If I search for "ACME" & "LEVEL2" I should get a result of 2.

I do not need to know which ones are unique, I just need to know the total of
unique items as long as the line meets the other two criteria. I'm not sure
if this is even possible. I'm using Excel 2000.

Thanks for any help you can give me!!

--
Message posted via http://www.officekb.com