How to find duplicate products and balance in excel?

H

Humashi2016-11-01 20:25:05

excel

Humashi, 2016-11-01 20:25:05

There are 2 columns with product codes and their quantity
. The 1st column may contain duplicate products (the same code) from the 2nd column
. th column)
code 3 is duplicated (10-2=8)
code 4 is duplicated (5-3=2)
I can't figure out the formula to check ranges, not cells line by line, any ideas guys?

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

A

Anton Fedoryan, 2016-11-02
@Humashi

Column G
Column H

M

murlogen, 2016-11-01
@murlogen

Sort by name
Write the formula "If the name from the current line is the same as the name from the previous line, then 1"
Further - elementary.