Oct 06 2021 01:30 PM
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.
Oct 06 2021 01:42 PM
SolutionOct 07 2021 05:56 AM
@Sergei Baklan thank you!
Oct 07 2021 01:20 PM
@ALFischer , glad to help
Oct 06 2021 01:42 PM
SolutionAs here
unique values
=UNIQUE(A2:A135)
sum of qty
=SUMIF(A2:A135, H2#, B2:B135)