Formulas for...1. Counting unique cells 2. Display unique contents
 

Greetings-

I have two problems i've been searching for the answers to for a few
days now and have not found the anwer amongst other posts or web
sites.

I've got a sheet with values like so:

A B C
Date Shift Product
4/1/04 A N/A
4/1/04 B N/A
4/3/04 C Z9485
4/5/04 C Z8632
4/5/04 D N/A
.... ... ...

One:
The letters in column "B" are work shifts. Shifts occur only once per
day. There will be mutliple entries with the same date and shift.
(i.e. 10 rows in column A and B which are populated with both 4/1/04
and "A") There are 4 shifts: A, B, C and D. I'd like to count each
time a unique date and shift occur. So for all the 4/1/04 and "A"
produces a count of 1. For all entries on 4/1/04 and "B" again
produces a 1.

Two:
I need to search the contents of column C which contains only names
starting with "Z" and "N/A" (these produced by a formula themselves)
and display on another sheet all of the "Z" names. In other words on
the oppositte sheet choosing from the above list, it would display
Z9485, Z8632.

I do not want to get involved with any macros here. A solution should
work with an array formula, but i'm not experienced with these yet.
The date and shift values will be pasted from elsewhere and will be
different every time, so I can't use any filtering. (after pasting,
it should do the work for me)

Any help is appreciated!
J