How to compare three colums and add difference?

[ZELIUS]

I have this problem, I have three columns with data:


A B C
1 98 98 ?
2 98
3 12
4 98
5 02




Column A has the serial numbers of all my products, column B the ones that have been sold, and column C I need to formulate how many of the serial numbers from column A I have remanding after removing the ones from colum B.

This is what I need the program to formulate:


A B C
1 98 98 98

2 98 98
3 12
4 98
5 02

How can i achieve this?

Thank you very mcuh!!

 

[Meesam_ali]

Use "=SUMPRODUCT(--(C2:H10=B2:B10))" in column-C and use as an array formula. For that press "Ctrl + Shift + Enter" after writing formula.

 

[Oscar Cronquist]

I don't understand the question, however, Meesam_ali's formula can be made into a regular formula if you change it to:
=SUMPRODUCT((C2:H10=B2:B10)*1)

No need to enter it as an array formula.