SOLVED

Duplicates with different values in another column

Copper Contributor

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.  

3 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@ALFischer 

As here

image.png

unique values

=UNIQUE(A2:A135)

sum of qty

=SUMIF(A2:A135, H2#, B2:B135)
1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@ALFischer 

As here

image.png

unique values

=UNIQUE(A2:A135)

sum of qty

=SUMIF(A2:A135, H2#, B2:B135)

View solution in original post