Here one way to search for many criteria in a Table. In Excel 2007, Microsoft added the powerful Table functionality. One useful feature of Tables is the ability to filter any number of columns. The filter control for each column allows us to search for two criteria. However, when I use these filters I often have at least two problems with them.
Nanny is a character from Disney's 1961 feature film One Hundred and One Dalmatians, its 1996 live-action film and its 1997-98 television series. Nanny's very sweet and understanding. She can be very tough and loves the Dalmatian puppies dearly.
In its home country of England, the Staffordshire bull terrier is nicknamed the nanny dog, such is its reputation as a child's playmate and guardian. Despite his fierce appearance, this dog is a lover, not a fighter. The breed is gentle, docile, and always on the look out for fun.