Personally, I'd use Pivot Table.
Add first column as Row Label. Add Count of second column as Value field.
Then right click on Row labels. And Filter -> Value Filter -> Count of column 2 = 0.
Edit: If you need the other way around, just use filter for Count of column 2 greater than 0.
"Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
― Robert A. Heinlein
Hi Fluff,
The count you supplied works perfectly - however, I should apologise because the original post wasn't clear, because what we want to do is return the group value rather than return a count total.
e.g.
Cerbera
T350
Rather than 2.
My apologies for the lack of clarity in the ask.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
FAU5T 
Register To Reply
Bookmarks