Duplicates with different values in another column

Hi everyone, 

I am using Excel 365.  I removed a lot of columns and changed the values for privacy.  I have a list of  numbers (column A) and many of those numbers occur more than once in the file (I highlighted duplicate values).  I created a distinct number list in column E using the advance filter.  I am trying to see if a number has a qty in column B.  A number can have multiple lines without a qty but as long as it has one line with it is good.  I know I can't use a vlookup because I need the formula to look at all the rows the number has to determine if a number has at least one row with a qty.  I am stumped and looking for ideas.