Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
You didn't array enter them as we explained in our answers.
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) wrote in message ... Thanks Bob, Teethless mama. However, both the formulae result in 3 for the following data: a1 f a1 g b1 h b1 c1 c1 p d1 d1 p whereas, it should show 0. (Because, no seat is free- each one is occupied in some shift(s)) Thanks again... for your time. ~Animesh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting unique entries with criteria | Excel Discussion (Misc queries) | |||
Counting Unique Entries | Excel Discussion (Misc queries) | |||
Counting unique entries | Excel Discussion (Misc queries) | |||
Counting Unique Entries | Excel Discussion (Misc queries) | |||
counting unique entries in a list | Excel Discussion (Misc queries) |