I have an Excel file that column B has a list of loan numbers in which many loan numbers appear multiple times. Column D and E return a Yes or No based off of other criteria. How can I easily look to the list and return only loan numbers where all loan numbers have both a yes in column D and E. In other words, if both row 5 and 6 are the same loan number, but one has a Yes in both column D and E and the other only has one Yes, neither occurrence of this loan number should appear.
Bookmarks